View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006907 | SymmetricDS | Bug | public | 2025-05-28 15:07 | 2025-05-28 17:00 |
| Reporter | mdrouard | Assigned To | mdrouard | ||
| Priority | normal | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | 3.14.9 | ||||
| Target Version | 3.15.17 | Fixed in Version | 3.15.17 | ||
| Summary | 0006907: Sybase ASE ERROR: value too long for type character varying(255). with rapid insert and delete with Latin-1 -> UTF-8 | ||||
| Description | Replicating Sybase (Latin-1) -> Postgres (UTF-8), UNIVARCHAR(255) column with sybase.ase.convert.unitypes.for.sync = true Fails to convert unitype in ExtractDataReader.convertUtf16toUTF8(). This causes Symmetric to attempt to insert hex into the UNIVARCHAR(255) column. Results in - ERROR: value too long for type character varying(255) | ||||
| Steps To Reproduce | 1.a. Set up Sybase DB with Latin-1 collation b. Create Sybase table with UNIVARCHAR(255) column 2.a. Create Postgres DB with UTF-8 collation b. Create Postgres table with CHARACTER VARYING(255) column 3. Set up table in Symmetric to replicate Sybase -> Postgres 4. Set the following parameter: sybase.ase.convert.unitypes.for.sync = true 5. Insert then delete in quick succession in Sybase with data that is around 255 characters. | ||||
| Tags | dialect: sybase | ||||
|
SymmetricDS: 3.15 92500c91 2025-05-28 16:32:24 Committer: GitHub Details Diff |
0006907: Sybase ASE ERROR: value too long for type character (#286) |
Affected Issues 0006907 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/reader/ExtractDataReader.java | Diff File | ||
|
SymmetricDS: 3.16 69468c47 2025-05-28 16:32:24 Committer: pbelov Details Diff |
0006907: Sybase ASE ERROR: value too long for type character (#286) |
Affected Issues 0006907 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/reader/ExtractDataReader.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-05-28 15:07 | mdrouard | New Issue | |
| 2025-05-28 15:07 | mdrouard | Status | new => assigned |
| 2025-05-28 15:07 | mdrouard | Assigned To | => mdrouard |
| 2025-05-28 15:07 | mdrouard | Tag Attached: dialect: sybase | |
| 2025-05-28 15:08 | mdrouard | Relationship added | related to 0005921 |
| 2025-05-28 16:31 | pbelov | Status | assigned => confirmed |
| 2025-05-28 16:33 | pbelov | Fixed in Version | => 3.15.17 |
| 2025-05-28 16:43 | pbelov | Status | confirmed => resolved |
| 2025-05-28 16:43 | pbelov | Resolution | open => fixed |
| 2025-05-28 17:00 | mdrouard | Changeset attached | => SymmetricDS 3.15 92500c91 |
| 2025-05-28 17:00 | pbelov | Changeset attached | => SymmetricDS 3.16 69468c47 |