View Issue Details

IDProjectCategoryView StatusLast Update
0004298SymmetricDSBugpublic2022-07-27 18:59
Reportermatej.vehar@easy.bi Assigned Toelong  
Priorityhigh 
Status closedResolutionfixed 
Product Version3.11.5 
Target Version3.14.0Fixed in Version3.14.0 
Summary0004298: Sycing schemas from MSSQL with column type CHAR(400) to MySQL fails
DescriptionMSSQL has max lenght of CHAR type = 8000, but MySQL/MariaDB has max lenght of CHAR type = 255.
I would suggest mapping on MySQL side to VARCHAR(X)

e.g.
MSSQL has column CHAR(X)
MySQL mapps to column VARCHAR(X)

If possible this conversion can be done only if X (length) exceeds 255.
Steps To ReproduceCreate MSSQL table with column of type CHAR(400) and perform initial load/schame sync to MySQL database
Tagsddl/schema

Relationships

related to 0003963 closedelong char(n) and nchar(n) where n>255 is valid in oracle but maps to invalid types in MariaDB 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-03-04 11:52 matej.vehar@easy.bi New Issue
2020-03-04 13:08 elong Project SymmetricDS Pro => SymmetricDS
2020-03-04 13:09 elong Tag Attached: ddl/schema
2022-05-27 16:18 elong Relationship added related to 0003963
2022-05-27 16:18 elong Assigned To => elong
2022-05-27 16:18 elong Status new => resolved
2022-05-27 16:18 elong Resolution open => fixed
2022-05-27 16:18 elong Fixed in Version => 3.14.0
2022-05-27 16:18 elong Target Version => 3.14.0
2022-07-27 18:59 admin Status resolved => closed