Re: Converting to UTF8

On 02/03/11 21:50, Javier Guerra Giraldez wrote:
> On Wed, Mar 2, 2011 at 4:21 PM, Tim Sawyer<list.django@calidris.co.uk> 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 html headers
> 8: the browser
> all know that the data is utf-8
Fixed it, thanks.

There were two problems.

1) I hadn't actually created the database using utf8 encoding it was
still latin1 (oops!)
2) I needed to edit the .sql file after running iconv so it had

SET client_encoding = 'UTF-8';

instead of

SET client_encoding = 'LATIN1';

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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.