View Issue Details

IDProjectCategoryView StatusLast Update
0005483SymmetricDSImprovementpublic2022-10-04 15:15
Reportersanderc85 Assigned Toelong  
Status closedResolutionfixed 
Product Version3.14.1 
Target Version3.14.2Fixed in Version3.14.2 
Summary0005483: Cast TEXT to VARCHAR for all tables
DescriptionI'm trying to sync MySQL to MS SQL and I'm using an _SC collation. Because of this I have to change all columns from type (N)TEXT to (N)VARCHAR(MAX). Otherwise, SQL server will throw this error: Column or parameter 'row_data' has type 'ntext' and collation 'Latin1_General_100_CI_AS_KS_WS_SC'. The legacy LOB types do not support UTF-8 or UTF-16 encodings. Use types varchar(max), nvarchar(max) or a collation which does not have the _SC or _UTF8 flags.
Steps To ReproduceCreate in MS SQL a database with Latin1_General_100_CI_AS_KS_WS_SC collation. Try to sync columns of a longtype to this databases and see the error occur.


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 b47dcc34

2022-09-30 16:51:12

Sander C

Committer: GitHub Details Diff
0005483: Toggle to convert TEXT to VARCHAR in MS SQL (0000186)

* Set env var USE_VARCHAR_FOR_TEXT to create varchar for text types

* Use property for setting text-to-varchar

* Use short if for N-type
Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/ Diff File

Issue History

Date Modified Username Field Change
2022-09-30 13:18 sanderc85 New Issue
2022-09-30 16:51 elong Assigned To => elong
2022-09-30 16:51 elong Status new => resolved
2022-09-30 16:51 elong Resolution open => fixed
2022-09-30 16:51 elong Fixed in Version => 3.14.2
2022-09-30 16:51 elong Target Version => 3.14.2
2022-09-30 16:51 elong Tag Attached: ddl/schema
2022-09-30 17:00 Changeset attached => SymmetricDS 3.14 b47dcc34
2022-10-04 15:15 admin Status resolved => closed