Re: Unicode and unaccent()

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Mark Borins" <mark(dot)borins(at)rigadev(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unicode and unaccent()
Date: 2005-05-06 06:12:24
Message-ID: 200505060812.24701.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mark Borins wrote:
> My problem is that the values like \342 are for LATIN1 type encoding.
> I have tried and failed to get this working using the what I think
> is the Unicode escaping method \u0032 for example.

There is no Unicode escaping method. You need to encode the characters
into UTF-8 yourself and write out the individual bytes using the octal
escape sequences.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Himanshu Baweja 2005-05-06 06:27:36 Wht all database profiler / performance monitoring tools are available
Previous Message Peter Eisentraut 2005-05-06 06:10:14 Re: Booleans - Why in Postgres and not in Oracle or Mysql?