soumik.bhattacharjee@xxxxxxx 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
