From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: olaf@cbk.poznan.pl
Cc: pgsql-sql@postgresql.org
Subject: Re: Unicode and escaping single quotes
Date: Wed, 12 Jun 2002 15:01:56 +0900 (JST)
Message-ID: <20020612.150156.58431751.t-ishii@sra.co.jp> (raw)
In-Reply-To: <1023808795.1622.19.camel@venus>
References: <1023808795.1622.19.camel@venus>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: t-ishii@sra.co.jp, olaf@cbk.poznan.pl
Subject: Re: Unicode and escaping single quotes
In-Reply-To: <20020612.150156.58431751.t-ishii@sra.co.jp>
References: <1023808795.1622.19.camel@venus> <20020612.150156.58431751.t-ishii@sra.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox