View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005483 | SymmetricDS | Improvement | public | 2022-09-30 13:18 | 2022-10-04 15:15 |
| Reporter | sanderc85 | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.1 | ||||
| Target Version | 3.14.2 | Fixed in Version | 3.14.2 | ||
| Summary | 0005483: Cast TEXT to VARCHAR for all tables | ||||
| Description | I'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 Reproduce | Create 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. | ||||
| Tags | ddl/schema | ||||
|
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 0005483 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2005DdlBuilder.java | Diff File | ||
| 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 |