View Issue Details

IDProjectCategoryView StatusLast Update
0006774SymmetricDSBugpublic2025-04-04 17:06
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.15Fixed in Version3.15.15 
Summary0006774: Sybase ASE unitext error when exceeding 8192 characters
DescriptionOn Sybase ASE, when a table is using a UNITEXT data type, if the value for an insert or update using more than 8192 characters AND it contains characters not valid in the server's character set, the following error is received:

"A wrong datastream has been sent to the server. The server was expecting token 1 but got the token 0."

A reported fix is to convert the characters to bytes representing UTF-16LE (little endian) and send in the byte array as a BLOB data type. Fix is reported to work with JTDS as well as Sybase drivers.
Steps To ReproduceReported in PRO customer ticket [GBY-69953-417]
Tagsdialect: sybase

Relationships

related to 0006798 closedelong Sybase ASE unitext error when exceeding 8192 characters 

Activities

pbelov

2025-03-31 20:31

manager   ~0002754

Merged PR https://github.com/JumpMind/symmetric-ds/pull/241

pbelov

2025-04-04 17:06

manager   ~0002791

Included in the 3.15.15 release

Related Changesets

SymmetricDS: 3.15 a5388432

2025-03-31 20:30:07

elong


Committer: GitHub Details Diff
0006774: Sybase ASE unitext error when exceeding 8192 characters (0000241) Affected Issues
0006774
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ase/AseDmlStatement.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ase/AseDatabasePlatform.java Diff File

SymmetricDS: 3.16 0021a153

2025-03-31 20:30:07

elong

Details Diff
0006774: Sybase ASE unitext error when exceeding 8192 characters (0000241) Affected Issues
0006774
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ase/AseDmlStatement.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ase/AseDatabasePlatform.java Diff File

Issue History

Date Modified Username Field Change
2025-03-20 17:50 elong New Issue
2025-03-20 17:50 elong Status new => assigned
2025-03-20 17:50 elong Assigned To => elong
2025-03-20 17:50 elong Tag Attached: dialect: sybase
2025-03-31 19:13 pbelov Steps to Reproduce Updated View Revisions
2025-03-31 19:38 elong Status assigned => resolved
2025-03-31 19:38 elong Resolution open => fixed
2025-03-31 19:38 elong Fixed in Version => 3.15.15
2025-03-31 20:31 pbelov Note Added: 0002754
2025-03-31 21:00 elong Changeset attached => SymmetricDS 3.15 a5388432
2025-04-01 19:26 elong Issue cloned: 0006798
2025-04-01 19:26 elong Relationship added related to 0006798
2025-04-01 21:00 elong Changeset attached => SymmetricDS 3.16 0021a153
2025-04-04 17:06 pbelov Status resolved => closed
2025-04-04 17:06 pbelov Note Added: 0002791