Closed
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