Data Type to store Leading Zero(0)

Поиск
Список
Период
Сортировка

Hello Experts,

 

As per business needs we need to store Zero(0) in primary key column of table  with this kind of value à  07******** with applications written in Java microservices.

 

We are not able to use numeric data type as it trims the Zero value in leading, but it’s also a performance impact if we define varchar in the data type.

 

Please suggest.

 

Thanks

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: "William Sescu (Suva)"
Дата:
Сообщение: 3 Parameters in pg_settings in CamelCase
Следующее
От: Nidhi Gupta
Дата:
Сообщение: Re: Data Type to store Leading Zero(0)