[SQL] RE : [SQL] Convert text from UTF8 to ASCII

2009-03-13 Thread seb JACK
3/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-

Re: [SQL] Convert text from UTF8 to ASCII

2009-03-13 Thread Paul Dam
2009 16:43 Aan: Paul Dam CC: pgsql-sql@postgresql.org Onderwerp: 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

Re: [SQL] Convert text from UTF8 to ASCII

2009-03-11 Thread Paul Dam
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. > >

Re: [SQL] Convert text from UTF8 to ASCII

2009-03-11 Thread Leif B. Kristensen
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

2009-03-11 Thread Claus Guttesen
> 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

2009-03-11 Thread Paul Dam
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