Unicode and escaping single quotes

From: Olaf Frączyk <olaf(at)cbk(dot)poznan(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: Unicode and escaping single quotes
Date: 2002-06-11 15:19:55
Message-ID: 1023808795.1622.19.camel@venus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Matt 2002-06-11 16:19:05 inheritance problems
Previous Message Tom Lane 2002-06-11 14:28:40 Re: Efficient DELETE Strategies