Search Postgresql Archives

Re: encoding problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux