pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Unicode and escaping single quotes
3+ messages / 2 participants
[nested] [flat]

* Unicode and escaping single quotes
@ 2002-06-11 15:19  Olaf <olaf@cbk.poznan.pl>
  0 siblings, 1 reply; 3+ messages in thread

From: Olaf Frączyk @ 2002-06-11 15:19 UTC (permalink / raw)
  To: 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







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Unicode and escaping single quotes
@ 2002-06-12 06:01  Tatsuo Ishii <t-ishii@sra.co.jp>
  parent: Olaf <olaf@cbk.poznan.pl>
  0 siblings, 1 reply; 3+ messages in thread

From: Tatsuo Ishii @ 2002-06-12 06:01 UTC (permalink / raw)
  To: olaf@cbk.poznan.pl; +Cc: pgsql-sql

> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Unicode and escaping single quotes
@ 2002-06-12 07:28  Olaf <olaf@cbk.poznan.pl>
  parent: Tatsuo Ishii <t-ishii@sra.co.jp>
  0 siblings, 0 replies; 3+ messages in thread

From: Olaf Frączyk @ 2002-06-12 07:28 UTC (permalink / raw)
  To: Tatsuo Ishii <t-ishii@sra.co.jp>; +Cc: pgsql-sql

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 







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2002-06-12 07:28 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-11 15:19 Unicode and escaping single quotes Olaf <olaf@cbk.poznan.pl>
2002-06-12 06:01 ` Tatsuo Ishii <t-ishii@sra.co.jp>
2002-06-12 07:28   ` Olaf <olaf@cbk.poznan.pl>

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