Skip site navigation (1) Skip section navigation (2)

Re: UNICODE

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Marko Kreen <marko(at)l-t(dot)ee>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UNICODE
Date: 2001-10-28 11:44:26
Message-ID: 4.2.0.58.20011028121057.00d1a100@pop.freesurf.fr (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
I only want this query to work under Unicode:
SELECT * FROM test WHERE source_content ILIKE '%accepté%'.

>* If client_encoding == server_encoding, the bytes are put into
>   DB as-is - no conversion is done.
>
>So are you absolutely sure you have on client side UTF8 strings?
PostgreSQL is compiled with UNICODE and LOCALE support.
Unicode is used on both ends (PostgreSQL and psql).

>Unfortunately you cant use client_encoding=latin1 as PostgreSQL
>refuses the do the conversion between them.  (I am with 7.1.3)
According to the on-line manual, only MULE provides instant transcoding.

>Eg. I did the following:
>
>* created db with encoding = UNICODE
>* Put your example into test.sql
>* iconv -f latin1 -t utf8 test.sql > test2.sql
>* psql < test2.sql
>
>and it worked as it should...

Nice to hear it works when transcoding files to UTF-8. It shows it is not a 
back-end problem.

As for me, I typed INSERT INTO source_content VALUES ('Permis de conduire 
accepté') in Psql.
Psql does not insert the data and I have to kill it manually. Can you 
reproduce this?

Best regards,
Jean-Michel POURE

In response to

Responses

pgsql-hackers by date

Next:From: Marko KreenDate: 2001-10-28 12:05:47
Subject: Re: UNICODE
Previous:From: Marko KreenDate: 2001-10-28 10:53:55
Subject: Re: UNICODE

pgsql-admin by date

Next:From: Marko KreenDate: 2001-10-28 12:05:47
Subject: Re: UNICODE
Previous:From: Marko KreenDate: 2001-10-28 10:53:55
Subject: Re: UNICODE

pgsql-general by date

Next:From: Marko KreenDate: 2001-10-28 12:05:47
Subject: Re: UNICODE
Previous:From: Uros GruberDate: 2001-10-28 11:38:21
Subject: Problem with some function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group