https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Anthony <bugzi...@inbox.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |bugzi...@inbox.org
--- Comment #152 from Anthony <bugzi...@inbox.org> 2009-11-25 05:42:19 UTC ---
Peter, for PostgreSQL you can ignore all the hacks and workarounds and just use
the built in collation.
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 ('aaa');
INSERT 0 1
a=# insert into category values ('banana');
INSERT 0 1
a=# insert into category values ('aáa');
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=# insert into category values ('aab');
INSERT 0 1
a=# select * from category order by title;
title
--------
aaa
aáa
aab
apple
Apple
APPLE
banana
Banana
(8 rows)
The easiest solution would probably be to drop support for MySQL. Not that
that's ever going to happen.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
