Re: Writing a NULL in a CHAR field

On 11 Sep 2003 at 11:04, Andrew Kuebler wrote: > Are BLOB column types the only columns that will let you write a NULL > (Hexidecimal 0) and still write beyond that? CHAR, CHAR BINARY, > VARCHAR, and VARCHAR BINARY all seem to truncate the string and stop > at the first null even if I escape the s

Writing a NULL in a CHAR field

Are BLOB column types the only columns that will let you write a NULL (Hexidecimal 0) and still write beyond that? CHAR, CHAR BINARY, VARCHAR, and VARCHAR BINARY all seem to truncate the string and stop at the first null even if I escape the string being updated. I don't want to use a BLOB column