Mariadb, diferent decimal lenght if collation is utf8 or latin_bin

marcosgambeta / sqlrddpp

SQLRDD for Harbour++ and Harbour

GNU General Public License v2.0

11 stars 6 forks source link

Mariadb, diferent decimal lenght if collation is utf8 or latin_bin #21

Open pcordonet opened 4 months ago

pcordonet commented 4 months ago

Hello, I have a problem with a database with MariaDb.

When I create a table with numeric fields for example 4 digits with collation "latin_bin", when I do dbstruct() it tells me that the size is 5 digits.

On the other hand if I have the collation "utf8_general_ci" it returns the correct value.

How can I fix this issue?

Thank you Petter