Page 1 of 1

Sybase ODBC quote character 000

Posted: Tue Nov 29, 2005 5:35 pm
by lgharis
We created a new job today with an ODBC stage for a Sybase table. The ODBC connection works fine. We imported a table definition. We had to put 000 in the "ODBC quote character" field for the "View Data" to work successfully. Can someone enlighten me as to the significance of 000 in this field?
I have searched the this forum, the DataDirect forums and the internet with no success.

Posted: Tue Nov 29, 2005 6:08 pm
by chulett
Three zeroes as the quote character indicates that there is no quote character in the data.

Posted: Wed Nov 30, 2005 1:17 am
by ray.wurlod
A three-digit number in this field is interpreted as the decimal ASCII value of the quote character. The same technique can be used in the delimiter character and quote character fields in Sequential File stages.

If you have NLS enabled you can also use a four-digit hexadecimal number which is the Unicode code point for the quote/delimiter character.