Latest updates on Autocomplete using SQL
Read more about Autocomplete using SQL »
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) [...]
I need to efficiently sort my texts in several languages in the same application. How?
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
My language is neither pre-defined nor available for download. Can I define the Collation myself?
Of course, let us define a collation for Sango (with orthography from http://www.rosettaproject.org): SQL>CREATE COLLATION sango FROM eor USING [...]
I want to change the sort order in a pre-defined language. How?
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 [...]
How do I make language sensitive searches?
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 [...]
Are contractions handled correctly in Mimer SQL?
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 [...]
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 [...]
How do I ignore prefixes like “de” and “van” in my sorted list of names?
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'); [...]