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.