On Tue, Aug 30, 2005 at 09:39:40AM -0400, Guy Doune <cesium5500@xxxxxxxx> wrote a message of 28 lines which said: > for getting postgresql accepting my entry with accent an all the > what the french poeple put over there caracter while they write... I use PostgreSQL with French data (names, addresses, etc). > I gonna continu to search why it doesn't work... You should give details such as commands attempted and error messages obtained. > I would know how to set the encoding (unicode, ASCII, etc.) I use Unicode (actually, "UTF-8" would have been a better name) because the database stores names in other languages, that you cannot express with Latin-1. I use the type TEXT and I can store and retrieve UTF-8 names (mostly via Python programs) and basic operators like LIKE work fine (for instance, _ matches one Unicode character, not one byte, which is the right thing). ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
