On Tue, Nov 24, 2009 at 7:57 PM, Domas Mituzas midom.lists@gmail.com wrote:
Ryan writes:
Any reason I would like to ask is why not use PostgreSQL?
Any reason we should?
Actually the main problem with using utf8 is that most of language- specific collations are case-insensitive, which would mean lots of pain with case senstive->case insensitive transition (due to how indexes work, it is relatively difficult to have efficient sorting order different from equality rules).
psql (8.4.1) Type "help" for help.
a=# create table category (title varchar(255) not null primary key); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "category_pkey" for table "category" CREATE TABLE a=# insert into category values ('Apple'); INSERT 0 1 a=# insert into category values ('Banana'); INSERT 0 1 a=# insert into category values ('Pear'); INSERT 0 1 a=# insert into category values ('banana'); INSERT 0 1 a=# insert into category values ('Orange'); INSERT 0 1 a=# insert into category values ('apple'); INSERT 0 1 a=# insert into category values ('Apple'); ERROR: duplicate key value violates unique constraint "category_pkey" a=# insert into category values ('APPLE'); INSERT 0 1 a=# select * from category order by title; title -------- apple Apple APPLE banana Banana Orange Pear (7 rows)