How do I present my existing Character data sorted in my own language (with pre-defined support in Mimer SQL)?
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 [...]
My language is not included in the pre-defined set. How can I use the definition available for download from the Mimer SQL web site?
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 [...]
I’ve stored numerical data as Character in the database. How can I have it sorted as numbers, not text (i.e. “10” should be greater than “9 “)?
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'); [...]