Re: encoding problem

jef peeraer schreef:
> i never thought i would be bblocked by an encoding problem :-(
> My database is in LATIN1 , i have entries like this in a table called
> gemeenten
>     Column     |   Type   |                       Modifiers
> ---------------+----------+--------------------------------------------------------
>
>  id            | integer  | serial....
>  gemeente      | text     | not null
>  postcode      | smallint | not null
>  provincies_id | integer  |
>
> This data is copied from a dump from that table
>
> 9780    Quévy    7040    7
> 9781    Quévy-le-Grand    7040    7
> 9782    Quévy-le-Petit    7040    7
>
> So, the accents are there. But with my web page, which is set to
> ISO-8859-1, i don't get the accents.
> The web-pages are build with XUL, where i set the charset to ISO-8859-1,
> but communication with the server is through  XMLHttpRequest.
> Do I have to specify the charset as well in the communication between
> server and client ? Or where else could it go wrong.
>
> jef peeraer
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

thanks for the help. The problem was lying in the fact that use
json_encode procedure from PHP. This procedure requires that the string
to be encoded be in UTF-8 format. So basically, my database stays in
LATIN1 and i set client encoding to UTF-8, as well as all web pages.


jef peeraer