> I want to put unicode text.
> But in INSERT I have to escape ' (single quote character).
> Should I escape every BYTE which has the value of ASCII single quote
> character, or only real single quote characters (in unicode) - if I have
> a multibyte unicode character, it may be composed (looking at the string
> as an array of bytes) of a normal character and single quote character.
PostgreSQL accepts only UTF-8 encoding, which never has the value of
single quote except the ASCII real single quote.
--
Tatsuo Ishii