Use datatype smallint(1) for storing zero or use Boolean datatype.
On Wed, Jan 20, 2021, 4:43 PM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:
> 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
>
>
>