Hello All.
What SQL standard is telling about charset introducers (such as "_utf8
'abc'")?
From my knowledge it can be interpreted in two ways:
1) Following byte sequence has given charset.
2) Following character sequence must be used as a string in given charset.
First option resuts in heavy limitation for query text transliteration and may end up
in single usable case when the literal is a binary string of hexadecimal form.
Second option makes the introducer a shortcut for CAST('abc' as CHAR CHARACTER SET
utf8) but allow the query text to be freely transliterated between application and engine.
I have this question because Unicode version of ODBC interface needs query text in
fixed UTF-16 and it result in a transliteration problem.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
