Hello I run PostgreSQL 7.4.6 on Linux with a JDBC client.
I initialised my database cluster with the following initdb command: initdb --locale=en_GB.UTF-8 --encoding UNICODE I have now discovered that my database cannot distinguish Japanese names or words - it throws unique constraint errors on a composite primary key that includes a VARCHAR field which stores the names or words. My tests indicate that the database treats all Japanese names/words as equal. Having searched the forum archives, it seems to me that I should have specified "--locale=C" as the locale setting when I initialised my database cluster. I am planning to re-initialise my database cluster using the following command: initdb --locale=C --encoding UNICODE Then, after defining the relevant groups and users, I intend to call pg_restore with reference to a "tar.gz" dump file of my data. I wonder if someone might be kind enough to confirm that this is the right approach to solving the problem. Many thanks! Harry Mantheakis London, UK ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
