Hi everyone. I’m facing an issue related to the object of this topic. The application I’m developing is based on postgresql and I have a table for saving enterprises data (name of the company, national code, address, etc…).
When I try to update the data of a record of the enterprise table, where the national code is a numeric code that begins with 0 (so in the DB it is saved as varchar), I get an error of format of that national code data because it begins with 0. When I create a new record of an enterprise and click save, the national code is saved without the initial 0. How can I fix this?
Thanks for the support and I hope I’ve been sufficiently clear.