Data sometimes corrupted under MS SQLServer

[Nils Jänicke]

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