Please do not top post. If you're using gmail's new reply interface, click on the "..." to reply inline.
On Tue, Dec 18, 2012 at 12:28 PM, Baptiste GONOD <baptiste.go...@gmail.com>wrote: > Can you just create a database UTF8 and say me the psql -l return ? To see > if you have windows.1252 on collate. > I wouldn't have that because my server is linux so my collation is en_US.UTF8. I just tested on a French Windows server and the collation is "French, France" > More, if you have an application UTF8, test to insert data (with char as > "é € à"...) then open pgadmin to consult them. > For me : "é à €" give "é à €". utf8 is encoded in 1252. You can > replicate that with notepadd++ typing "é à €", convert to utf8, then > encoded in ANSI (or 1252 the same things). > This works as desired for me.
