soumik.bhattacharjee@kpn.com schrieb am 20.01.2021 um 12:13:
> 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 aperformance impact if we define *varchar*
> in the data type.
While there is a performance impact between an integer and varchar, in my experience
it's rarely that big that it will become a problem.
Thomas