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

connect engine odbc type table Simplified Chinese display error

    XMLWordPrintable

Details

    Description

      Mariadb connect engine odbc type table,connecting oracle database,Simplified Chinese display error.

      Replication method:
      odbc.ini configuration file:

      		[oracletest]
      		Application Attributes = T
      		Attributes = W
      		BatchAutocommitMode = IfAllSuccessful
      		BindAsFLOAT = F
      		CloseCursor = F
      		DisableDPM = F
      		DisableMTS = T
      		Driver = /opt/instantclient_12_1/libsqora.so.12.1
      		DSN = ulodbc 
      		EXECSchemaOpt =
      		EXECSyntax = T
      		Failover = T
      		FailoverDelay = 10
      		FailoverRetryCount = 10
      		FetchBufferSize = 64000
      		ForceWCHAR = F
      		Lobs = T
      		Longs = T
      		MaxLargeData = 0
      		MetadataIdDefault = F
      		QueryTimeout = T
      		ResultSets = T
      		ServerName = //172.16.110.13:1521/orcl 
      		SQLGetData extensions = F
      		Translation DLL =
      		Translation Option = 0
      		DisableRULEHint = T
      		UserID = scott
      		password = tiger
      		StatementCache=F
      		CacheBufferSize=20
      		UseOCIDescribeAny=F
      		SQLTranslateErrors=F
      		MaxTokenSize=8192
      		AggregateSQLType=FLOAT
      		CharacterSet=AL32UTF8
      

      oracle:

      		create table t(c1 varchar2(10),c2 varchar2(10));
      		insert into t values('呵','呵');
      		insert into t values('Mariadb','Mariadb');
      		commit;
      

      mariadb:
      odbc table:

      			"root@127.0.0.1 Tue Oct 11 09:47:42 2016 09:47:42 [test]>CREATE TABLE t ENGINE=CONNECT TABLE_TYPE=ODBC tabname='T' dbname='SCOTT' CONNECTION='DSN=oracletest;UID=scott;PWD=tiger;' option_list='Block_Size=100000,Scrollable=true' DATA_CHARSET=utf8 CHARSET=utf8; 
      			Query OK, 0 rows affected (1.54 sec)
      			"root@127.0.0.1 Tue Oct 11 09:47:01 2016 09:47:01 [test]>select * from t;
      			+---------+---------+
      			| C1      | C2      |
      			+---------+---------+
      			| ?       | ?       |
      			| Mariadb | Mariadb |
      			+---------+---------+
      			2 rows in set (0.09 sec)
      

      Chinese is not the first line should not appear as '?'.
      This is why?

      		jdbc table
      			"root@127.0.0.1 Tue Oct 11 09:58:06 2016 09:58:06 [test]>CREATE TABLE t1 ENGINE=CONNECT TABLE_TYPE=JDBC tabname='T' CONNECTION="jdbc:oracle:thin:@172.16.110.13:1521:orcl" OPTION_LIST="User=scott,Password=tiger";       
      			Query OK, 0 rows affected (0.45 sec)
       
      			"root@127.0.0.1 Tue Oct 11 09:58:18 2016 09:58:18 [test]>select * from t1;    
      			+---------+---------+
      			| C1      | C2      |
      			+---------+---------+
      			| 呵      | 呵      |
      			| Mariadb | Mariadb |
      			+---------+---------+
      			2 rows in set (0.07 sec)
      

      jdbc table display is normal.

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            smilejiodb SmileJi
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.