About EasyMorph Tutorials & Examples Web-help

MySQL and accents

Hello,

I have a sort of bug. When i use MySQL Connector and accents in column name i have this :slight_smile:

Imgur

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:

  • Test the SELECT '' as "tétètù" query on your side. Will it give you a correct or an incorrect column name?
  • Tell me what default collation does the target table and database schema have?

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.

Imgur

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?

To learn more about EasyMorph visit easymorph.com.