From: Pomarede N. <npo...@co...> - 2004-08-02 16:13:30
|
Hello, first of all, congratulations to all the contributors for this very very=20 good tool you made. I have a question regarding charset conversion with postgres (I hope this= =20 is not the wrong place, but I didn't find any user list) : I created some tables under postgres, encoded in SQL_ASCII. This tables contains varchar with accents like =E9=E8=E0=EA ... When I use psql to query these tables, I get a correct output (accents are= =20 preserved). It's also OK when using pgAdmin III But when I use TOra, each time such a character is encoutered, I get 2=20 space instead. I think this is an encoding problem, so is there a possibility to open a=20 postgres connection with the equivalent of setting "\encoding SQL_ASCII"=20 for example ? I read in the recent news that unicode support was added to mysql through= =20 a patched QT3 version. does it mean that accents support for psql would=20 also need a special patched version ? I'm using tora-alpha-1.3.14.1-1mdk.i686.rpm under a Mandrake 10.0 Thanks for any answer, I'm really looking forward to be able to use TOra=20 to edit these tables ---------------- Nicolas Pomarede e-mail: npo...@co... |