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-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] Namens Leif B. Kristensen Verzonden: woensdag

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 >

Re: [SQL] Convert text from UTF8 to ASCII

> I store content of an .txt file in a text column in the database. > > server_encoding is UTF8. What does 'psql -l' say? -- regards Claus When lenity and cruelty play for a kingdom, the gentler gamester is the soonest winner. Shakespeare -- Sent via pgsql-sql mailing list (pgsql-sql@postgre

[SQL] Convert text from UTF8 to ASCII

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