UNICODE. Met vriendelijke groet, Paul Dam Informatieanalist
Amyyon Bijsterhuizen 11.58 6546 AS Nijmegen 050 - 311 5686 www.amyyon.nl -----Oorspronkelijk bericht----- Van: [email protected] [mailto:[email protected]] Namens Leif B. Kristensen Verzonden: woensdag 11 maart 2009 16:46 Aan: [email protected] 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
