Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.18
-
centeos 6
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.