On Thu, Aug 30, 2012 at 6:09 AM, F. BROUARD / SQLpro <sqlpro@xxxxxxxxxxxxxxxx> wrote: > Le 30/08/2012 12:45, Craig Ringer a écrit : > > >> That's my understanding, but I don't know which other database systems >> you're talking about because you've never specifically named any. >> > In his primary post he talk about SQL Server, Sybase and MySQL wich does > good jobs with collation.... > > Almost a majority of RDBMS have collation support wich is very important for > non english languages, that represents about 90% of the planet languages ! > > This feature has always been a "black spot" in PG, and the most important > topic to discourage to use it in professionnal applications. Citations please. PostgreSQL has excellent collation support. http://www.postgresql.org/docs/9.1/static/collation.html Sybase performance on upper() case insensitive searchs: http://stackoverflow.com/questions/81268/case-insensitive-search-on-sybase MySQL case insensitive searchs rely on indexing upper or lower functions just like PostgreSQL and use seq scans for collation induced case insensitive searchs: http://use-the-index-luke.com/sql/where-clause/functions/case-insensitive-search Further PostgreSQL has the citext type: http://www.postgresql.org/docs/9.1/static/citext.html Which can be handy for case insensitive searches but can ONLY do case insensitive stuff. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
