Character encoding issue when connecting from MariaDB to Oracle DB using unixODBC in CentOS

144 Views Asked by At

After connecting to MariaDB and executing the following command CREATE TABLE ora_emp ENGINE=CONNECT TABLE_TYPE=ODBC TABNAME='tablename' CONNECTION='DSN=ORCL;UID=userid;PWD=pass'; INSERT INTO test.ora_emp(gubun1, gubun2) VALUES ('한', '글') SELECT * FROM ora_emp enter image description here As you can see, it is displayed as ??. How can I resolve this issue?

  1. I have changed all the character sets in MariaDB to euckr. enter image description here
  2. I have added 'Charset = euckr' to the [ORCL] section of the /etc/odbc.ini file.
  3. I have set the environment variable NLS_LANG to KOREAN_KOREA.KO16KSC5601.
0

There are 0 best solutions below