Thread: Unicode and escaping single quotes

Hi,
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.

Please CC me.

Best Regards,

Olaf Fraczyk

> 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

On Wed, 2002-06-12 at 08:01, Tatsuo Ishii wrote:
> PostgreSQL accepts only UTF-8 encoding, which never has the value of
> single quote except the ASCII real single quote.
Yes, you are right, I should have read standard first :)
Regards,

Olaf Fraczyk