RE: [SQL] RE : [SQL] Convert text from UTF8 to ASCII
Sebastien,
I know by looking at the data using PgAdmin.
Met vriendelijke groet,
Paul Dam
Informatieanalist
Amyyon
Bijsterhuizen 11.58
6546 AS Nijmegen
050 - 311 5686
Van: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] Namens seb JACK
Verzonden: vrijdag 13 maart 2009 13:49
Aan: pgsql-sql@postgresql.org
Onderwerp: [SQL] RE : [SQL] Convert text from UTF8 to ASCII
Hi
Perhaps you should try to set your db client_encoding to UTF8.
How do you know you have 'patiënt' instead of 'patiënt'?
I mean i also deals with UTF8 databases and all i store is correctly stored. But i can't check it with command line psql as my shell is configured with iso-8859-1 charset.
So with psql i will also see 'patiënt' even if 'patiënt' is correctly stored!
Perhaps your problem is as simple as that!?
Sebastien.
De: pgsql-sql-owner@postgresql.org de la part de Paul Dam
Date: mer. 11/03/2009 16:51
À: Leif B. Kristensen; pgsql-sql@postgresql.org
Objet : Re: [SQL] Convert text from UTF8 to ASCII
UNICODE.
Met vriendelijke groet,
Paul Dam
Informatieanalist
Amyyon
Bijsterhuizen 11.58
6546 AS Nijmegen
050 - 311 5686
www.amyyon.nl
-----Oorspronkelijk bericht-----
Van: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] Namens Leif B. Kristensen
Verzonden: woensdag 11 maart 2009 16:46
Aan: pgsql-sql@postgresql.org
CC: Paul Dam
Onderwerp: Re: [SQL] Convert text from UTF8 to ASCII
On Wednesday 11. March 2009, Paul Dam wrote:
>Hoi,
>
>
>
>I store content of an .txt file in a text column in the database.
>
>server_encoding is UTF8.
>
>
>
>If the .txt file is in ASCII this is correctly stored in the database.
>
>If the .txt file is in UTF8 this is NOT correctly stored in the
> database.
>
>
>
>Examples:
>
>In Dutch the term for patient is 'patiënt'.
>
>It is stored as 'patiënt'.
That looks a lot like UTF-8 to me. What is your client-encoding?
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
В списке pgsql-sql по дате отправления: