CHR$(0) thru CHR$(31) in SQL statement
CHR$(0) thru CHR$(31) in SQL statement
(OP)
I work for a company that has numerous Btrieve tables that use CHR$(0) thru CHR$(31) for flags and status of records. Ten years ago it made sense due to the cost of memory (a STRING*1 versus INTEGER*2 {there was no INTEGER*1 back then}).
Unfortunately, when you submit a SQL statement to the server with a variable equal to NULL (CHR$(0)) the SQL engine truncates the statement at the null and, of course, trips an error.
PROBLEM: How do I use Chr$(0) thru Chr$(31) as legitimate values for "SELECT" and "INSERT" commands in variables without SQL hiccuping?
RE: CHR$(0) thru CHR$(31) in SQL statement
Alternatively you could store that data in a data type intended for binary data. In Oracle that would be "RAW" or "LONG RAW". I can't comment about SQL Server because I use a *proper* database <smile>
Regards
Mike