When submitting queries using function LEFT on a client that uses ODBC, disable ODBC parsing. Otherwise, the query may be altered by ODBC to a SUBSTR function call.
Character Sets Supported
The following character sets are supported with the LEFT function:
- Unicode
- Latin
- Kanji SJIS
- Graphic