Data sometimes corrupted under MS SQLServer

General discussion forum about all databases other than SqlBase.
Nils Jänicke
Germany
Posts: 423
Joined: 20 Sep 2017, 11:56
Location: Villingen-Schwenningen, Germany

Data sometimes corrupted under MS SQLServer

Post by Nils Jänicke » 22 Apr 2008, 09:45

SQLServer 2005, connected by ODBC, TD 5.1 SP2
Sometimes data are corrupted after retreiving into variables. I cannot reproduce a simple example, but I show you d screenshot:
The content of the datafield (varchar(254)) should be:
"%' And formname not in (select formname from zmen0151 where gruppe = :frmZMEN010004.dfGruppe Or :frmZMEN010004.dfGruppe IS NULL) And formname Like'"

The content retreived from database is:
"%' And formname not in (select formname from zmen0151 where gruppe = :frmZMEN010004.dfGruppe Or :frmZMEN010004.dfGruppe IS NUL"
This string is exactly 126 characters long. SalStrGetBufferLength() gives the correct result of 296 Bytes wich is the length of the datafield, 147, multiplied by 2 and the two bytes for the termination.

It seems that these problems are often in our app and it makes it very unstable.
PLEASE CHECK YOUR UNICODE FUNCTIONALITY!!!

Nils
You do not have the required permissions to view the files attached to this post.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 4 guests