Unicode Collation FAQ

For example, sorted in traditional Spanish order: SQL>SELECT chardata FROM t ORDER BY chardata COLLATE spanish_traditional_3; Observe that character data uses the ISO/IEC 8859-1 (Latin-1) [...]

For example, sorting Swedish names in either Swedish or English (accent and case sensitive): SQL>create table t (names nvarchar(30)); SQL>insert into t values('Arlanda'); SQL>insert into [...]

For example, click on Maori to get the Maori Collation Chart, then click on Collation to get the CREATE COLLATION statement: SQL>CREATE COLLATION maori FROM eor USING SQL>'&N

Of course, let us define a collation for Sango (with orthography from http://www.rosettaproject.org): SQL>CREATE COLLATION sango FROM eor USING [...]

For example, changing the sort order for tone marks in Vietnamese to GRAVE, HOOK ABOVE, TILDE, ACUTE, and DOT BELOW: SQL>CREATE COLLATION new_vietnamese_3 FROM vietnamese_3 SQL>USING [...]

Here are some examples: SQL>create table t (word varchar(10)); SQL>insert into t values('COOP'); SQL>insert into t values('coop'); SQL>insert into t values('COÖP'); SQL>insert into t [...]

Yes, here is an example: SQL>-- In Danish AA is a contraction equal to Å SQL>create table t(name varchar(10)); SQL>insert into t values(U&'Aller\00F8d'); SQL>insert into t [...]

Look at the following example: SQL>create table alphanum (codes varchar(10)); SQL>insert into alphanum values('A123'); SQL>insert into alphanum values('A234'); SQL>insert into [...]

See the following example: SQL>create table t (names varchar(10)); SQL>insert into t values('van Gogh'); SQL>insert into t values('van Damme'); SQL>insert into t values('Janssen'); [...]