Search Postgresql Archives

Which locale to use for multiple-language support?

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

 



Hi,

Some of postgresql's string functions behave differently depending on the locale the cluster was created with. With the locales 'C' or 'en_US.utf8', lower() does not lowercase non-ascii characters such as Ü (umlaut-u).

If we have users from all over the world storing data in our database with all sorts of languages, which locale should we use to ensure these string functions behave as they expect?

Thanks,

--
David Edwards

[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