Could you show your stored procedure, as well as the actual call you make
(including the 'compressed' string) to reproduce this problem?
Also, is SQL Server 2000 at SP3?
Aaron Bertrand, SQL Server MVP
Please reply in the newsgroups, but if you absolutely
must reply via e-mail, please take out the TRASH.
"Erik Ommundsen" <eommundsstud.hia.no> wrote in message
news:be0fc65f.0307010340.6fa17d03posting.google.c om...> Hi, folks!
> In my application I am compressing a large string using zlib (in VB6),
> and want to store this in a MSSQL2000 database. When storing this
> compressed string in a field with the datatype "text", some of the
> bytes "disappear", probably because of escape-characters or something
> like that... (?) The length of the string i inserted is a few bytes
> longer than the length of the string i selected afterwards.
> I am using stored procedures to insert into and select data from the
> Have anyone experienced problems like this before?
> If this happens because of escape-characters, which characters must
> "be taken care of"?
> Should I rather use a binary datatype, such as "Image"?
> I'm using VB6 and MSSQL 2000 sp3.
> Erik Ommundsen