search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
523 stars 161 forks source link

Character encoding conflict #195

Closed WUHAN563 closed 4 years ago

WUHAN563 commented 4 years ago

Hello,

I’m using mysql_fdw with “import foreign schema...”. When the encodings are different between pg and MySQL(for example UTF8 and GBK), some of the data is messed up. Is it possible to have an option identifying and converting character encodings between pg and MySQL?

Thanks.

WUHAN563 commented 4 years ago

There is an option of "mysql_init_command". I will try it with "set names 'utf8'" firstly.

WUHAN563 commented 4 years ago

set option of _initcommand to set names 'utf8'. That works.

The issue is closed.