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 has utf8 encoding
db_utf8=> \i db-utf8.sql
If I query this data inside the psql prompt, it works:
db_utf8=> select name from app_table where slug = 'harry-strksen';
name
-----------------
Harry Størksen
However, my web page now gets Harry Størksen instead.
Switching back to the LATIN1 database, all is fine.
Does anyone have any clues as to why this doesn't work and what I can do
to fix it?
Cheers,
Tim.
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
