On Tue, Nov 24, 2009 at 7:57 PM, Domas Mituzas <midom.lists(a)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)