Brass Tilde wrote:
I was hoping for some database wide setting (using 3.x). Is there not one?
The default collating sequences is called BINARY. You can redefine
BINARY to be the same as NOCASE if you want. Then when tables use
the default collating sequence, they will use NOCASE instead of
BINARY.
I presume using the collate clause is something on the order of:
create table participant
(
partkey integer primary key not null,
lastname varchar(40) not null collate nocase,
firstname varchar(40) null collate nocase
);
That is correct.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
