latin1_german1_cs

MySQL-dump

May 08

latin1_german1_cs

For a migration, I needed a latin1_german1_cs collation, that is, I needed German umlauts to sort as their base characters.

Here is what to do: Find your charsets directory with "SHOW VARIABLES LIKE 'char%dir%'".

Inside that directory will be a file Index.xml. Find a free id and add your new collation using an unused id. Add a description and a name.

Inside the same directory is a file latin1.xml. Inside that file, copy the block of the collation matching your new collation most closely, and adapt it as needed. In my case, I changed latin1_german1_ci to _cs, and modified the character values to match.

Patch attached after the break.

How to use:

After applying the patch, the server must be restarted. "SHOW COLLATION" will now show the new latin1_german1_cs collation. "ALTER TABLE t CHANGE COLUMN oldcol newcol varchar(80) CHARSET latin1 COLLATE latin1_german1_cs NOT NULL" will change any old column to the new collation and recreate indices as needed.

Because we changed a single byte character set, we do not need to recomple anything. Try sorting by latin1_bin, latin1_german1_ci and latin1_german1_cs to observe how things are different with each collation.
linux:/usr/local/mysql-max-5.0.18-linux-i686-glibc23/share/mysql/charsets # diff -u Index.xml.orig Index.xml; diff -u latin1.xml.orig latin1.xml
--- Index.xml.orig 2006-05-08 14:41:11.000000000 +0200
+++ Index.xml 2006-05-08 15:13:38.000000000 +0200
@@ -115,6 +115,7 @@
<alias>l1</alias>
<alias>latin1</alias>
<collation name="latin1_german1_ci" id="5" order="German Duden"/>
+ <collation name="latin1_german1_cs" id="99" order="German Duden"/>
<collation name="latin1_swedish_ci" id="8" order="Finnish, Swedish" flag="primary"/>
<collation name="latin1_danish_ci" id="15" order="Danish"/>
<collation name="latin1_german2_ci" id="31" order="German Phonebook" flag="compiled"/>
--- latin1.xml.orig 2006-05-08 14:41:18.000000000 +0200
+++ latin1.xml 2006-05-08 15:12:04.000000000 +0200
@@ -154,6 +154,27 @@
</map>
</collation>

+<collation name="latin1_german1_cs">
+<map>
+ 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
+ 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
+ 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
+ 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
+ 40 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
+ 50 51 52 53 54 55 56 57 58 59 5A 5B 5C 5D 5E 5F
+ 60 61 62 63 64 65 66 67 68 69 6A 6B 6C 6D 6E 6F
+ 70 71 72 73 74 75 76 77 78 79 7A 7B 7C 7D 7E 7F
+ 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F
+ 90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F
+ A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
+ B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
+ 41 41 41 41 41 41 41 43 45 45 45 45 49 49 49 49
+ D0 4E 4F 4F 4F 4F 4F D7 4F 55 55 55 55 59 DE 53
+ 61 61 61 61 61 61 61 43 65 65 65 65 69 69 69 69
+ F0 6E 6F 6F 6F 6F 6F F7 6F 75 75 75 75 79 FE FF
+</map>
+</collation>
+

<collation name="latin1_danish_ci">
<map>
Posted by Kristian Köhntopp in I18N at 15:59 | Comments (0) | Trackback (1)

Trackbacks
Trackback specific URI for this entry

Zeichensatzärger
Choose any font you like Seit MySQL 4.1 existiert in MySQL Support für Zeichensätze und Sortierreihenfolgen. Das bedeutet im Wesentlichen, daß an jedem CHAR, VARCHAR und TEXT in der Datenbank und an jeder Stringkonstante dranklebt, in welcher Codierung
Weblog: Die wunderbare Welt von Isotopp
Tracked: Aug 06, 21:24

Comments
Display comments as (Linear | Threaded)

No comments

Add Comment

E-Mail addresses will not be displayed and will only be used for E-Mail notifications

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

BBCode format allowed
 
 

Quicksearch

Comments

santosh about An InnoDB tutorial
Mon, 21.07.2008 11:13
I have a problem in deleting t he child table row from my app lication using unique id. when I am using the command [...]


Azundris about Nermalisation
Sat, 05.07.2008 16:08
The point is that you have the option to not do, but then yo u'll be in a world of pain. Th e point is also to show [...]


fdask about Nermalisation
Fri, 04.07.2008 15:40
Nice little article, and I lik e how you've used cats in your examples :) I am a little unclear what the point h [...]


Salmiakki about Salmiakki - the official MySQL Drink
Sun, 08.06.2008 11:34
150g of liquorice are enough t o get the original Salmiakki t aste.... you can add some more , anyway


mohammad about DB Designer becomes MySQL Workbench
Wed, 28.05.2008 05:41
It's very good


delbertino about phpvikinger.org: Things that have no name
Sun, 11.05.2008 06:34
In reply to "stuff with no nam es":very informative and succi nct. I am retired and need to learn to build a website [...]


ashok about What is the difference between MySQL and Postgres?
Wed, 30.04.2008 14:08
what is the difference between MySql and PostgreSql?


fortunecookienotes about Fortune Cookie
Wed, 09.04.2008 21:46
What a random fortune, who kno ws what it means. My favorite random fortune cookie note rea ds "you will make a good [...]


Categories


All categories

Authors


All authors

Syndicate This Blog

Blog Administration

Open login screen

Disclaimer

All examples, code-snippets, advice, trivia, etc. are supplied in the hope that they are useful, but no warranty of any kind is given. Use of trademarks is not intended as a challenge to them.

Impressum

Copyright 2005-2007 bei den jeweiligen Autorinnen der Beiträge. Die Infrastruktur von MySQL-dump wird betrieben von: Azundris, Immanuelkirchstraße 18, 710405 Berlin, Germany