Hello,
I have a sort of bug. When i use MySQL Connector and accents in column name i have this
Hello Thomas,
I tested it on my side, and it worked correctly:
So it must be an encoding or MySQL configuration issue.
Can you please:
SELECT '' as "tétètù"
query on your side. Will it give you a correct or an incorrect column name?Same prb. It only appear on MySQL connection.
SELECT VERSION(); = 5.1.66-0+squeeze1-log
Ho i can retrieve the collation ? i’m not the administrator of the database.
You can retrieve the character set and collation (if it was specified explicitly) of a database and a table with the following queries:
SHOW CREATE DATABASE database_name
SHOW CREATE TABLE table_name
Sorry,
I missed your post ^^’
Here is the result :
CREATE DATABASE FACT_MID
/*!40100 DEFAULT CHARACTER SET latin1 /
CREATE DATABASE mid_jasper
/!40100 DEFAULT CHARACTER SET latin1 */
I have another MySQL DB where the character set is UTF8 and there is no prb.
Thomas, thank you for the info. Unfortunately, I still can’t reproduce the issue, even with a database in latin1 encoding. But I’m testing on the MySQL 5.7.14-log, so it’s possible that your version and my version treats latin1 encoding differently.
What type of connector you are using? ODBC or EasyMorph’s native connector? If it’s an ODBC connector - what ODBC driver and which version you are using?
Also, which EasyMorph version you are using?