Re: Converting to UTF8

2011-03-02 Thread Tim Sawyer
On 02/03/11 21:50, Javier Guerra Giraldez wrote: On Wed, Mar 2, 2011 at 4:21 PM, Tim Sawyer wrote: However, my web page now gets Harry Størksen instead. looks like part of your stack is still interpreting utf-8 data as latin1 check that 1: the field 2: the table 3: the database 4: the client

Re: Converting to UTF8

2011-03-02 Thread Javier Guerra Giraldez
On Wed, Mar 2, 2011 at 4:21 PM, Tim Sawyer wrote: > However, my web page now gets Harry Størksen instead. looks like part of your stack is still interpreting utf-8 data as latin1 check that 1: the field 2: the table 3: the database 4: the client connection 5: the webapp 6: the template 7: the h

Converting to UTF8

2011-03-02 Thread Tim Sawyer
Hi, I have a postgres database that is LATIN1. It contains extended characters, for example Harry Størksen. I dumped this out to a file: pg_dump -U dbuser db > db.sql and then ran iconv iconv --from-code latin1 --to-code utf-8 db.sql > db-utf8.sql and then imported into a database which h