[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