BUG: Mapped Binary Data in ESQL-C Truncates Data After 0x00 (152112)
The information in this article applies to:
- Microsoft SQL Server 4.2x
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.
| Modification Type: | Major | Last Reviewed: | 2/20/2002 |
|---|
| Keywords: | KB152112 |
|---|
|