Weird issue with some characters in a script
Posted: 10.02.2021, 14:31
Hi
I'm using 7.2.6 with Lazarus 2.0.10, connected to a MariaDb 10 Database, utf-8 charset selected everywhere.
I get a syntax error when I execute in a ZSqlProcessor this :
But with this one (only one "E" has been removed in the country name), for example : no problem !
The first script run without error in another SQL client (SquirrelSQL), or when executed in a mysql command line with input from files.
I have attached a zip containing a small project reproducing the problem, and the 2 script files
Any idea about this strange issue ? Could someone try with Delphi ?
I'm using 7.2.6 with Lazarus 2.0.10, connected to a MariaDb 10 Database, utf-8 charset selected everywhere.
I get a syntax error when I execute in a ZSqlProcessor this :
Code: Select all
CREATE OR REPLACE TABLE Countries( CountryName VARCHAR(50) NOT NULL) DEFAULT CHARSET=utf8 ENGINE=InnoDB;
INSERT INTO Countries (CountryName) VALUES ('CAÏMANES, ÎLES');
Code: Select all
CREATE OR REPLACE TABLE Countries(CountryName VARCHAR(50) NOT NULL) DEFAULT CHARSET=utf8 ENGINE=InnoDB;
INSERT INTO Countries (CountryName) VALUES ('CAÏMANS, ÎLES');
I have attached a zip containing a small project reproducing the problem, and the 2 script files
Any idea about this strange issue ? Could someone try with Delphi ?