Hi,
Did you read the documentation? You need to use 'strength'. PRIMARY is
usually case- and umlaut-insensitive; SECONDARY is case-insensitive
but umlaut-sensitive; TERTIARY is both case- and umlaut-sensitive;
IDENTICAL is sensitive to all differences and only affects ordering).
Example:
drop all objects;
set collation PORTUGUESE_BRAZIL STRENGTH PRIMARY;
create table test(name varchar);
insert into test values('a'), ('A'), ('à'), ('b');
select * from test where name = 'a';
select * from test order by name;
drop all objects;
set collation PORTUGUESE_BRAZIL STRENGTH SECONDARY;
create table test(name varchar);
insert into test values('a'), ('A'), ('à'), ('b');
select * from test where name = 'a';
select * from test order by name;
drop all objects;
set collation PORTUGUESE_BRAZIL STRENGTH IDENTICAL;
create table test(name varchar);
insert into test values('a'), ('A'), ('à'), ('b');
select * from test where name = 'a';
select * from test order by name;
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
