Skip to content

Oracle to MySQL job some characters are copied wrong  #890

Closed
@asiroliu

Description

@asiroliu

Description

Oracle to MySQL job some characters are copied wrong

Steps to reproduce the issue

  1. create oracle to mysql job
  2. oracle execute sql
CREATE TABLE ACTION_DB.CHAR_255_COLUMNS(col1 INT, col2 CHAR(255))
INSERT INTO ACTION_DB.CHAR_255_COLUMNS VALUES (9, ' ')  # insert a string with one space
INSERT INTO ACTION_DB.CHAR_255_COLUMNS VALUES (11, CHR(39))
  1. check result on MySQL
mysql> SELECT COL2 FROM ACTION_DB.CHAR_255_COLUMNS WHERE COL1=9;
+------+
| COL2 |
+------+
|      |.           # it's a empty string
+------+
1 row in set (0.00 sec)

mysql> SELECT ASCII(COL2) as COL2 FROM ACTION_DB.CHAR_255_COLUMNS WHERE COL1=11;
+------+
| COL2 |
+------+
|    0 |
+------+
1 row in set (0.00 sec)

Output of ./dtle version:**

9.9.9.9-master-a65ee13

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions