-
Notifications
You must be signed in to change notification settings - Fork 137
Closed
Labels
Description
Description
Oracle to MySQL job some characters are copied wrong
Steps to reproduce the issue
- create oracle to mysql job
- 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))- 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