Do you mean we should create a db with a specific COLLATE and then depending on the user's locale we should change the queries? for example like this:
SELECT * FROM test1 ORDER BY a || b COLLATE "fr_FR";
From: Tom Lane <tgl@sss.pgh.pa.us> To: Gregory Kotsaftis <gregkotsaftis@yahoo.com> Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org> Sent: Thursday, July 26, 2012 12:53 AM Subject: Re: [NOVICE] Is there an answer to the Ultimate Question for PostgreSQL?
Gregory Kotsaftis <gregkotsaftis@yahoo.com> writes: > Let's assume someone would wish to create an application to be used by many different users from different countries, simultaneously. > The data should be stored within the same database and shared among all users and also, each user should be able to execute upper(), lower(), order by, etc. properly for his locale.
> Is PostgreSQL up to the task? Sure we could use UTF8 for the database encoding, but what can be done about the different locales?