On Tue, Nov 24, 2009 at 7:57 PM, Domas Mituzas <[email protected]> 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)
_______________________________________________
Wikitech-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
