Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.6, 10.3.7, 10.3.8, 10.3.9
-
None
-
CentOS7, Oracle 11g, Character Set Oracle WE8ISO8859P1, Character Set MariaDB utf8mb4
Description
Hello,
in MariaDB 10.2.11 I create a connect-table from mariadb to orcacle with the following statement:
CREATE TABLE `hzEdatValues` ( |
`EDAT_DEF_ID` int(10) unsigned NOT NULL, |
`VALUE` varchar(40) NOT NULL, |
`TEXT_K` varchar(512) NOT NULL, |
`TEXT_E` varchar(4000) DEFAULT NULL, |
`CODES` varchar(4000) DEFAULT NULL, |
`SORT` int(10) unsigned NOT NULL, |
`SP_KZ` varchar(1) NOT NULL, |
`SP_TEXT` varchar(255) DEFAULT NULL, |
`NEU_DATUM` datetime NOT NULL, |
`NEU_USR_ID` int(10) unsigned NOT NULL, |
`AEND_DATUM` datetime NOT NULL, |
`AEND_USR_ID` int(10) unsigned NOT NULL |
) ENGINE=CONNECT DEFAULT CHARSET=utf8mb4 CONNECTION='DSN=HHZ1' `TABLE_TYPE`='ODBC' `DATA_CHARSET`=latin1 `tabname`='CHZ.HZ_A_EDAT_VALUES' |
In oracle the character set is WE8ISO8859P1 and in mariadb utf8mb4.
Characters as 'ä', 'Ü' was shown correct in the connect-table.
Then we update mariadb to 10.3.6. Now the characters as 'ä' or 'Ü' are shown wrong in the connect-table: 'ä' -> 'a' and 'Ü' -> 'U'.
Now we use mariadb 10.3.9 and the characters are still wrong.
Can you help me?