Hi, Yes I read the documentation, but I don't seen the java.text.Collator documentation because I thought that package was H2 and as not found there, I was test with "set collation PORTUGUESE_BRAZIL" only, so it did not work.
Thank's a lot for your help and sorry for the inconvenience. You are the best. I use this database since 2006 and never experienced this situation uses. Now it worked exactly as I expected. Regards, Rodrigo Macedo On 2 jul, 12:02, Thomas Mueller <[email protected]> wrote: > 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.
