Postgres Pro
Downloads
Home   >   mailing lists

Re: Unicode and unaccent() - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Unicode and unaccent()
Date
Msg-id 200505060812.24701.peter_e@gmx.net
Whole thread Raw
In response to Unicode and unaccent()  ("Mark Borins" <mark.borins@rigadev.com>)
Responses Re: Unicode and unaccent()
List pgsql-general
Tree view 
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/

pgsql-general by date:

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