VB & Database, Embedded NULL Character in a string -SQL Server

Embedded NULL Character in a string -SQL Server

Author	Message
Karthik Krishna #1 / 4	Embedded NULL Character in a string -SQL Server Hi, I am having a big string with embedded Null(Chr$(0)) Character in it. I am trying to insert a record with a blob field containing this big string. I could do it without any problem in DAO. But in ADO, I could not use direct INSERT Statement as it fails on finding NULL Character. I tried to convert the data to HEX and update the TEXT/var binary data type in SQL Server 7.0. This works fine but the restriction here is, it cannot take more than 8000 characters as we are typecasting to VARCHAR. All these work nicely in SQL ANYWHERE as SQL ANYWHERE database supports data input in HEX. Any clues? Regards, Karthik.
Fri, 30 Aug 2002 03:00:00 GMT

Karthik Krishna #2 / 4	Embedded NULL Character in a string -SQL Server Hi, I am having a big string with embedded Null(Chr$(0)) Character in it. I am trying to insert a record with a blob field containing this big string. I could do it without any problem in DAO. But in ADO, I could not use direct INSERT Statement as it fails on finding NULL Character. I tried to convert the data to HEX and update the TEXT/var binary data type in SQL Server 7.0. This works fine but the restriction here is, it cannot take more than 8000 characters as we are typecasting to VARCHAR. All these work nicely in SQL ANYWHERE as SQL ANYWHERE database supports data input in HEX. Any clues? Regards, Karthik.
Fri, 30 Aug 2002 03:00:00 GMT

Karthik Krishna #3 / 4	Embedded NULL Character in a string -SQL Server Hi, I am having a big string with embedded Null(Chr$(0)) Character in it. I am trying to insert a record with a blob field containing this big string. I could do it without any problem in DAO. But in ADO, I could not use direct INSERT Statement as it fails on finding NULL Character. I tried to convert the data to HEX and update the TEXT/var binary data type in SQL Server 7.0. This works fine but the restriction here is, it cannot take more than 8000 characters as we are typecasting to VARCHAR. All these work nicely in SQL ANYWHERE as SQL ANYWHERE database supports data input in HEX. Any clues? Regards, Karthik.
Fri, 30 Aug 2002 03:00:00 GMT

Karthik Krishna #4 / 4	Embedded NULL Character in a string -SQL Server Hi, I am having a big string with embedded Null(Chr$(0)) Character in it. I am trying to insert a record with a blob field containing this big string. I could do it without any problem in DAO. But in ADO, I could not use direct INSERT Statement as it fails on finding NULL Character. I tried to convert the data to HEX and update the TEXT/var binary data type in SQL Server 7.0. This works fine but the restriction here is, it cannot take more than 8000 characters as we are typecasting to VARCHAR. All these work nicely in SQL ANYWHERE as SQL ANYWHERE database supports data input in HEX. Any clues? Regards, Karthik.
Fri, 30 Aug 2002 03:00:00 GMT

Page 1 of 1

[ 4 post ]