Re: Convert text from UTF8 to ASCII

From: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Cc: "Paul Dam" <p(dot)dam(at)amyyon(dot)nl>
Subject: Re: Convert text from UTF8 to ASCII
Date: 2009-03-11 15:46:29
Message-ID: 200903111646.30330.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Paul Dam 2009-03-11 15:51:31 Re: Convert text from UTF8 to ASCII
Previous Message Claus Guttesen 2009-03-11 15:43:25 Re: Convert text from UTF8 to ASCII