BUG: Mapped Binary Data in ESQL-C Truncates Data After 0x00
Article ID: 152112
Article Last Modified on 2/20/2002
APPLIES TO
- Microsoft SQL Server 4.21a Standard Edition
This article was previously published under Q152112
SYMPTOMS
When you insert binary data into a text/image, binary or varbinary
column, using dynamic ESQL-C SQL statements with variables mapped to C
memory regions, the data can be truncated if it contains an embedded
0x00.
WORKAROUND
Converting the values to the ASCII equivalents and prefixing the string
with "0x" (0x01020003 --> "0x01020003") will ensure all data is inserted
into the column.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Embedded SQL
for C Programmer's Toolkit version 4.22. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
This problem does not occur
with Microsoft Embedded SQL for C Programmer's Toolkit version 6.5.
Additional query words: ESQL-C MAPPED MEMORY
Keywords: KB152112