Create collation fails
От | Čikić Nenad |
---|---|
Тема | Create collation fails |
Дата | |
Msg-id | 50B0AE7D.4020107@gmail.com обсуждение исходный текст |
Ответы |
Re: Create collation fails
|
Список | pgsql-novice |
Hello! I am novice linux,postgre,psql and so on :) I am using ubuntu 11.10, postgre 9.1 My database has: server_encoding UTF8 lc_collate en_US.UTF8 I am developing an application for android and I want to serve multilingual data. I thought of using on android unicode collation algorithm, and I will do, but I have non consistent behaviour and googling it seems that on android it does not behave always well. So I thought of serving clients on their request such for example select * from xxx order by collation fr_FR To check this behaviour I have found that I have to do ( as explained by mr Lelarge in http://postgresql.1045698.n5.nabble.com/Specifying-column-level-collations-td4378231.html) CREATE COLLATION fr (locale='fr_FR'); but then it does not worked for me so I have found that I have to do (as explained in http://archives.postgresql.org/pgsql-bugs/2011-03/msg00013.php) apt-get install language-pack-fr the second language-support-fr does not exist though. Well still my psql CREATE COLLATION statement fails. So I have 2 questions: 1. How can I talk to french girls in their collation? 2. Is the idea of using "order by collation" on utf8 data stupid? Thanks Cikic Nenad
В списке pgsql-novice по дате отправления: