Postgres Pro
Downloads
Home   >   mailing lists

Re: Convert text from UTF8 to ASCII - Mailing list pgsql-sql

From Paul Dam
Subject Re: Convert text from UTF8 to ASCII
Date
Msg-id 28DD271C986F234A9B4573938292C1B31BD706@s0008.a-more.org
Whole thread Raw
In response to Re: Convert text from UTF8 to ASCII  ("Leif B. Kristensen" <leif@solumslekt.org>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Leif B. Kristensen"
Date:
Subject: Re: Convert text from UTF8 to ASCII
Next
From: Allan Kamau
Date:
Subject: Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field