• Products
    • Product Overview
    • Downloads
    • Documentation
    • Platform Articles
  • News
  • Features
    • SQL Standard
    • Multilingual Support
    • Database APIs
    • Feature Articles
  • Services
    • Support and training
    • FAQ
    • SQL Validator
    • SQL Unicode Collation Charts
    • Howto Articles
    • Developer Tools
    • External Resources
  • About Us
    • Contact
    • Careers
  • Mimer.com
  • S
  • Products
    • Product Overview
    • Downloads
    • Documentation
    • Platform Articles
  • News
  • Features
    • SQL Standard
    • Multilingual Support
    • Database APIs
    • Feature Articles
  • Services
    • Support and training
    • FAQ
    • SQL Validator
    • SQL Unicode Collation Charts
    • Howto Articles
    • Developer Tools
    • External Resources
  • About Us
    • Contact
    • Careers
  • Mimer.com
  • S

Unicode Collation FAQ

Home » Unicode Collation FAQ
0
By Mimer
In
Posted 2018-12-18

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) [...]

READ MORE
0
By Mimer
In
Posted 2018-12-18

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 [...]

READ MORE
0
By Mimer
In
Posted 2018-12-18

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

READ MORE
0
By Mimer
In
Posted 2018-12-18

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 [...]

READ MORE
0
By Mimer
In
Posted 2018-12-18

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 [...]

READ MORE
0
By Mimer
In
Posted 2018-12-18

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 [...]

READ MORE
0
By Mimer
In
Posted 2018-12-18

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 [...]

READ MORE
0
By Mimer
In
Posted 2018-12-18

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 [...]

READ MORE
0
By Mimer
In
Posted 2018-12-18

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'); [...]

READ MORE
About Mimer SQL

Mimer SQL is the relational database that, from the same kernel, can be configured to target enterprise environments as well as embedded systems and mobile devices.

Latest News
  • Mimer SQL Data Provider for .NET 6 2022-10-21
  • Mimer SQL 11.0.7 now released for Linux! 2022-07-10
Customer Service
  • Contact us
  • Support
  • SQL Validator
  • Collation Charts
Product Basics
  • Product Overview
  • Downloads
  • Documentation
  • Mimer.com
Copyright © 1983 Mimer Information Technology AB · Cookies

We are using cookies to give you the best experience on our website.
You can find out more about which cookies we are using, and adjust them in the settings panel.

Mimer Developer
Powered by  GDPR Cookie Compliance
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookies should be enabled at all times so that we can save your preferences for cookie settings.

If you disable these cookies, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.