View Issue Details

IDProjectCategoryView StatusLast Update
0003076SymmetricDSBugpublic2019-05-31 16:06
Reportergwilmer Assigned Togwilmer  
Prioritynormal 
Status closedResolutionfixed 
Target Version3.8.22Fixed in Version3.8.22 
Summary0003076: MySQL binary collation sequence causes incorrect decoding of text data from source
DescriptionIf the source database platform is different than the target platform AND the target platform is MySQL and the target MySql database has fields of type TEXT (tinytext, longtext, mediumtext, text) AND the target database or table has a binary collation sequence, the target data load will incorrectly assume it was passed binary data for the field. This results in the target load attempting to decode text data incorrectly, resulting in errors such as follows:

Incorrect string value... for column...
TagsNo tags attached.

Relationships

related to 0001261 resolved reload-table doesn't work with tables that have collate latin1_bin 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 36f3b7c5

2017-04-26 13:45:57

gwilmer

Details Diff
Fixed 0003076. Affected Issues
0003076
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/MySqlDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2017-04-26 17:45 gwilmer New Issue
2017-04-26 17:45 gwilmer Status new => assigned
2017-04-26 17:45 gwilmer Assigned To => gwilmer
2017-04-26 17:46 gwilmer Resolution open => fixed
2017-04-26 17:46 gwilmer Fixed in Version => 3.8.22
2017-04-26 18:00 gwilmer Changeset attached => SymmetricDS 3.8 36f3b7c5
2017-04-26 18:00 gwilmer Status assigned => resolved
2017-05-01 18:03 chenson Status resolved => closed
2019-05-31 16:06 elong Relationship added related to 0001261