Re: [GENERAL] help with utf8

2005-12-01 Thread Richard Huxton
Hugo wrote: Richard, I have to import data from a CSV file with the pgsql COPY command, I just know that this file comes from an old program written in Clipper (or something like under linux) , my database was created with UTF8, I cant find how to create it with UTF-16 on windows, what is the r

Re: [GENERAL] help with utf8

2005-12-01 Thread Hugo
Richard,I have to import data from a CSV file with the pgsql COPY command, I just know that this file comes from an old program written in Clipper (or something like under linux) , my database was created with UTF8,  I cant find how to create it with UTF-16 on windows, what is the recomended encodi

Re: [GENERAL] help with utf8

2005-12-01 Thread Richard Huxton
Hugo wrote: don't know if this is the best solution but I dropped the database and recreated it with SQL_ASCII instead of UTF-8 and everything worked as expected It would SQL_ASCII just accepts whatever it's given. Hugo - a quick tip for future questions, just post the text of the message not

Re: [GENERAL] help with utf8

2005-12-01 Thread Hugo
don't know if this is the best solution but I dropped the database and recreated it with SQL_ASCII instead of UTF-8 and everything worked as expectedHugoOn 01/12/05, Hugo <[EMAIL PROTECTED]> wrote:Hi can anybody help with this error, I attatched an imagethanksPosgtrest 8.1.0 on WinXP Pro SP1