Hi Chris,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

This should not happen with String data type.

We do have a limitation, but that is partly a limitation from the SQL logic itself, if we import some data from an Excel/CSV or google Sheet which has 'leading zeroes' and if we don't make sure to set up a Column like that as "String type" during our Manual table import - our Plugin sometimes 'guesses' it should be a numeric field ( integer or float) then escapes the zeroes in the database.

But if your database properly shows this data in the Database and is marked as Text/Varchar, then this is strange.

Can you please send me an SQL Dump of this Table from your Database and we can import it here to do some testing and try to isolate the issue?

You can upload it to weTransfer for example and send a download link.

2. Or, actually, maybe I have a better idea.

Can you try to go in this Column Data settings, then just change the column type in our Plugin from numeric to String and this might resolve the issue right away?

Let me know if that helped.

If not, you can still send us an SQL dump from your Table then we can reproduce the issue here and isolate it.

If it contains any sensitive data, just mark the reply as PRIVATE, for security reasons.