Page 1 of 1

MySQL identifier case problems

Posted: 07.01.2021, 20:17
by leus
This patch solves problems I observed with mORMot's
CreateMissingTables
procedure. I think this patch is correct, however, I don't have the capabilities to test it.

The problem seems to be how case insensivity is treated in MySQL. Zeos tends to lowercase identifiers aggressively and this is making that table and columns extraction from a MySQL database hosted on Linux to fail.

Re: MySQL identifier case problems

Posted: 08.01.2021, 10:26
by marsupilami
Hello leus,

I am locking this thread in favour of viewtopic.php?f=40&t=131179#p162054.

Best regards,

Jan