Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17501

Connect-Storage engine: character set failure

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.3.6, 10.3.7, 10.3.8, 10.3.9
    • Fix Version/s: 10.3.12
    • Labels:
      None
    • Environment:
      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?

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              KB_Heinze Karsten Budde
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: