MySQL Forums
Forum List  »  Install & Repo

Custom utf8 Collation
Posted by: R S
Date: June 30, 2008 11:17AM

Hi Folks,

I'am in serious trouble at the moment developing my own utf8 collation.
Why do I develop an own collation? Because, as many others I have the problem that utf8_general_ci taking an ü for an u and so on.
I have some kind of keywords in a tables column which is unique. Now MySQL told
me:

"bar" is the same as "bär"

which is, IMHO, not correct.

My Solution was, as metioned above, developing an own collation where EVERY letter is a Primary letter. So that ü is not u and bar is not bär...

But now it seems that I ran into another MySQL shortcoming.

If I add all letters from "Utf-8 basic latin"/"latin supplement"/"latin extended A and B" (I parse the from a file ...) it seems that only the first X entries are relevent the rest is ignored.

For Example:
I'am fill the database with all basic latin letters in lower and upper case:
If I query the DB:
SELECT name FROM tailored WHERE name='a';

utf8_general_ci returns:
A
a
Ä
ä

with my own collation:
a

but when I'am trying the same with an L (SELECT name FROM tailored WHERE name='L';) the result even with my own collation is:
L
l

But I asked for L not for l ...!!

And know the magic thing I cant understand:

If I remove the <reset>/<p> Tags for letter a. L is working find but n doesnt do it anymore.
It feels like there is a limit of tags inside the <rules> Tag of my custom UTF8 collation.



Can anybody explain this?



@MySQL: If this limit exists... you cant possibly be serious guys ;)


Here is my Collation (UTF-8 Tag from Index.xml inclusivly):

<charset name="utf8">
<family>Unicode</family>
<description>UTF-8 Unicode</description>
<alias>utf-8</alias>
<collation name="utf8_general_ci" id="33">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_bin" id="83">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_wm" id="211">
<rules>
<reset>\u0041</reset><!--A-->
<p>\u0061</p><!--a-->
<p>\u00C0</p><!--A WITH GRAVE -->
<p>\u00C1</p><!--A WITH ACUTE -->
<p>\u00C2</p><!--A WITH CIRCUMFLEX -->
<p>\u00C3</p><!--A WITH TILDE -->
<p>\u00C4</p><!--A WITH DIAERESIS -->
<p>\u00C5</p><!--A WITH RING ABOVE -->
<p>\u00E0</p><!--a WITH GRAVE -->
<p>\u00E1</p><!--a WITH ACUTE -->
<p>\u00E2</p><!--a WITH CIRCUMFLEX -->
<p>\u00E3</p><!--a WITH TILDE -->
<p>\u00E4</p><!--a WITH DIAERESIS -->
<p>\u00E5</p><!--a WITH RING ABOVE -->
<p>\u0100</p><!--A WITH MACRON-->
<p>\u0101</p><!--a WITH MACRON-->
<p>\u0102</p><!--A WITH BREVE-->
<p>\u0103</p><!--a WITH BREVE-->
<p>\u0104</p><!--A WITH OGONEK-->
<p>\u0105</p><!--a WITH OGONEK-->
<p>\u01CD</p><!--A WITH CARON-->
<p>\u01CE</p><!--a WITH CARON-->
<p>\u01DE</p><!--A WITH DIAERESIS AND MACRON-->
<p>\u01DF</p><!--a WITH DIAERESIS AND MACRON-->
<p>\u01E0</p><!--A WITH DOT ABOVE AND MACRON-->
<p>\u01E1</p><!--a WITH DOT ABOVE AND MACRON-->
<p>\u01FA</p><!--A WITH RING ABOVE AND ACUTE-->
<p>\u01FB</p><!--a WITH RING ABOVE AND ACUTE-->
<p>\u01CD</p><!--A WITH CARON-->
<p>\u01CE</p><!--a WITH CARON-->
<p>\u01DE</p><!--A WITH DIAERESIS AND MACRON-->
<p>\u01DF</p><!--a WITH DIAERESIS AND MACRON-->
<p>\u01E0</p><!--A WITH DOT ABOVE AND MACRON-->
<p>\u01E1</p><!--a WITH DOT ABOVE AND MACRON-->
<p>\u01FA</p><!--A WITH RING ABOVE AND ACUTE-->
<p>\u01FB</p><!--a WITH RING ABOVE AND ACUTE-->
<p>\u0200</p><!--A WITH DOUBLE GRAVE-->
<p>\u0201</p><!--a WITH DOUBLE GRAVE-->
<p>\u0202</p><!--A WITH INVERTED BREVE-->
<p>\u0203</p><!--a WITH INVERTED BREVE-->
<p>\u0226</p><!--A WITH DOT ABOVE-->
<p>\u0227</p><!--a WITH DOT ABOVE-->
<p>\u023A</p><!--A WITH STROKE-->
<reset>\u0042</reset><!--B-->
<p>\u0062</p><!--b-->
<p>\u0180</p><!--b WITH STROKE-->
<p>\u0181</p><!--B WITH HOOK-->
<p>\u0182</p><!--B WITH TOPBAR-->
<p>\u0183</p><!--b WITH TOPBAR-->
<p>\u0180</p><!--b WITH STROKE-->
<p>\u0181</p><!--B WITH HOOK-->
<p>\u0182</p><!--B WITH TOPBAR-->
<p>\u0183</p><!--b WITH TOPBAR-->
<p>\u0243</p><!--B WITH STROKE-->
<p>\u0253</p><!--b WITH HOOK-->
<reset>\u0043</reset><!--C-->
<p>\u0063</p><!--c-->
<p>\u00C7</p><!--C WITH CEDILLA -->
<p>\u00E7</p><!--c WITH CEDILLA -->
<p>\u0106</p><!--C WITH ACUTE-->
<p>\u0107</p><!--c WITH ACUTE-->
<p>\u0108</p><!--C WITH CIRCUMFLEX-->
<p>\u0109</p><!--c WITH CIRCUMFLEX-->
<p>\u010A</p><!--C WITH DOT ABOVE-->
<p>\u010B</p><!--c WITH DOT ABOVE-->
<p>\u010C</p><!--C WITH CARON-->
<p>\u010D</p><!--c WITH CARON-->
<p>\u0187</p><!--C WITH HOOK-->
<p>\u0188</p><!--c WITH HOOK-->
<p>\u0187</p><!--C WITH HOOK-->
<p>\u0188</p><!--c WITH HOOK-->
<p>\u023B</p><!--C WITH STROKE-->
<p>\u023C</p><!--c WITH STROKE-->
<p>\u0255</p><!--c WITH CURL-->
<reset>\u0044</reset><!--D-->
<p>\u0064</p><!--d-->
<p>\u010E</p><!--D WITH CARON-->
<p>\u010F</p><!--d WITH CARON-->
<p>\u0110</p><!--D WITH STROKE-->
<p>\u0111</p><!--d WITH STROKE-->
<p>\u018A</p><!--D WITH HOOK-->
<p>\u018B</p><!--D WITH TOPBAR-->
<p>\u018C</p><!--d WITH TOPBAR-->
<p>\u01F2</p><!--D WITH SMALL LETTER Z-->
<p>\u018A</p><!--D WITH HOOK-->
<p>\u018B</p><!--D WITH TOPBAR-->
<p>\u018C</p><!--d WITH TOPBAR-->
<p>\u01F2</p><!--D WITH SMALL LETTER Z-->
<p>\u0221</p><!--d WITH CURL-->
<p>\u0256</p><!--d WITH TAIL-->
<p>\u0257</p><!--d WITH HOOK-->
<reset>\u0045</reset><!--E-->
<p>\u0065</p><!--e-->
<p>\u00C8</p><!--E WITH GRAVE -->
<p>\u00C9</p><!--E WITH ACUTE -->
<p>\u00CA</p><!--E WITH CIRCUMFLEX -->
<p>\u00CB</p><!--E WITH DIAERESIS -->
<p>\u00E8</p><!--e WITH GRAVE -->
<p>\u00E9</p><!--e WITH ACUTE -->
<p>\u00EA</p><!--e WITH CIRCUMFLEX -->
<p>\u00EB</p><!--e WITH DIAERESIS -->
<p>\u0112</p><!--E WITH MACRON-->
<p>\u0113</p><!--e WITH MACRON-->
<p>\u0114</p><!--E WITH BREVE-->
<p>\u0115</p><!--e WITH BREVE-->
<p>\u0116</p><!--E WITH DOT ABOVE-->
<p>\u0117</p><!--e WITH DOT ABOVE-->
<p>\u0118</p><!--E WITH OGONEK-->
<p>\u0119</p><!--e WITH OGONEK-->
<p>\u011A</p><!--E WITH CARON-->
<p>\u011B</p><!--e WITH CARON-->
<p>\u0204</p><!--E WITH DOUBLE GRAVE-->
<p>\u0205</p><!--e WITH DOUBLE GRAVE-->
<p>\u0206</p><!--E WITH INVERTED BREVE-->
<p>\u0207</p><!--e WITH INVERTED BREVE-->
<p>\u0228</p><!--E WITH CEDILLA-->
<p>\u0229</p><!--e WITH CEDILLA-->
<p>\u0246</p><!--E WITH STROKE-->
<p>\u0247</p><!--e WITH STROKE-->
<reset>\u0046</reset><!--F-->
<p>\u0066</p><!--f-->
<p>\u0191</p><!--F WITH HOOK-->
<p>\u0192</p><!--f WITH HOOK-->
<p>\u0191</p><!--F WITH HOOK-->
<p>\u0192</p><!--f WITH HOOK-->
<reset>\u0047</reset><!--G-->
<p>\u0067</p><!--g-->
<p>\u011C</p><!--G WITH CIRCUMFLEX-->
<p>\u011D</p><!--g WITH CIRCUMFLEX-->
<p>\u011E</p><!--G WITH BREVE-->
<p>\u011F</p><!--g WITH BREVE-->
<p>\u0120</p><!--G WITH DOT ABOVE-->
<p>\u0121</p><!--g WITH DOT ABOVE-->
<p>\u0122</p><!--G WITH CEDILLA-->
<p>\u0123</p><!--g WITH CEDILLA-->
<p>\u0193</p><!--G WITH HOOK-->
<p>\u01E4</p><!--G WITH STROKE-->
<p>\u01E5</p><!--g WITH STROKE-->
<p>\u01E6</p><!--G WITH CARON-->
<p>\u01E7</p><!--g WITH CARON-->
<p>\u01F4</p><!--G WITH ACUTE-->
<p>\u01F5</p><!--g WITH ACUTE-->
<p>\u0193</p><!--G WITH HOOK-->
<p>\u01E4</p><!--G WITH STROKE-->
<p>\u01E5</p><!--g WITH STROKE-->
<p>\u01E6</p><!--G WITH CARON-->
<p>\u01E7</p><!--g WITH CARON-->
<p>\u01F4</p><!--G WITH ACUTE-->
<p>\u01F5</p><!--g WITH ACUTE-->
<p>\u0260</p><!--g WITH HOOK-->
<reset>\u0048</reset><!--H-->
<p>\u0068</p><!--h-->
<p>\u0124</p><!--H WITH CIRCUMFLEX-->
<p>\u0125</p><!--h WITH CIRCUMFLEX-->
<p>\u0126</p><!--H WITH STROKE-->
<p>\u0127</p><!--h WITH STROKE-->
<p>\u021E</p><!--H WITH CARON-->
<p>\u021F</p><!--h WITH CARON-->
<p>\u0266</p><!--h WITH HOOK-->
<reset>\u0049</reset><!--I-->
<p>\u0069</p><!--i-->
<p>\u00CC</p><!--I WITH GRAVE -->
<p>\u00CD</p><!--I WITH ACUTE -->
<p>\u00CE</p><!--I WITH CIRCUMFLEX -->
<p>\u00CF</p><!--I WITH DIAERESIS -->
<p>\u00EC</p><!--i WITH GRAVE -->
<p>\u00ED</p><!--i WITH ACUTE -->
<p>\u00EE</p><!--i WITH CIRCUMFLEX -->
<p>\u00EF</p><!--i WITH DIAERESIS -->
<p>\u0128</p><!--I WITH TILDE-->
<p>\u0129</p><!--i WITH TILDE-->
<p>\u012A</p><!--I WITH MACRON-->
<p>\u012B</p><!--i WITH MACRON-->
<p>\u012C</p><!--I WITH BREVE-->
<p>\u012D</p><!--i WITH BREVE-->
<p>\u012E</p><!--I WITH OGONEK-->
<p>\u012F</p><!--i WITH OGONEK-->
<p>\u0130</p><!--I WITH DOT ABOVE-->
<p>\u0197</p><!--I WITH STROKE-->
<p>\u01CF</p><!--I WITH CARON-->
<p>\u01D0</p><!--i WITH CARON-->
<p>\u0197</p><!--I WITH STROKE-->
<p>\u01CF</p><!--I WITH CARON-->
<p>\u01D0</p><!--i WITH CARON-->
<p>\u0208</p><!--I WITH DOUBLE GRAVE-->
<p>\u0209</p><!--i WITH DOUBLE GRAVE-->
<p>\u020A</p><!--I WITH INVERTED BREVE-->
<p>\u020B</p><!--i WITH INVERTED BREVE-->
<p>\u0268</p><!--i WITH STROKE-->
<reset>\u004A</reset><!--J-->
<p>\u006A</p><!--j-->
<p>\u0134</p><!--J WITH CIRCUMFLEX-->
<p>\u0135</p><!--j WITH CIRCUMFLEX-->
<p>\u01F0</p><!--j WITH CARON-->
<p>\u01F0</p><!--j WITH CARON-->
<p>\u0248</p><!--J WITH STROKE-->
<p>\u0249</p><!--j WITH STROKE-->
<reset>\u004B</reset><!--K-->
<p>\u006B</p><!--k-->
<p>\u0136</p><!--K WITH CEDILLA-->
<p>\u0137</p><!--k WITH CEDILLA-->
<p>\u0198</p><!--K WITH HOOK-->
<p>\u0199</p><!--k WITH HOOK-->
<p>\u01E8</p><!--K WITH CARON-->
<p>\u01E9</p><!--k WITH CARON-->
<p>\u0198</p><!--K WITH HOOK-->
<p>\u0199</p><!--k WITH HOOK-->
<p>\u01E8</p><!--K WITH CARON-->
<p>\u01E9</p><!--k WITH CARON-->
<reset>\u004C</reset><!--L-->
<p>\u006C</p><!--l-->
<p>\u0139</p><!--L WITH ACUTE-->
<p>\u013A</p><!--l WITH ACUTE-->
<p>\u013B</p><!--L WITH CEDILLA-->
<p>\u013C</p><!--l WITH CEDILLA-->
<p>\u013D</p><!--L WITH CARON-->
<p>\u013E</p><!--l WITH CARON-->
<p>\u013F</p><!--L WITH MIDDLE DOT-->
<p>\u0140</p><!--l WITH MIDDLE DOT-->
<p>\u0141</p><!--L WITH STROKE-->
<p>\u0142</p><!--l WITH STROKE-->
<p>\u019A</p><!--l WITH BAR-->
<p>\u01C8</p><!--L WITH SMALL LETTER J-->
<p>\u019A</p><!--l WITH BAR-->
<p>\u01C8</p><!--L WITH SMALL LETTER J-->
<p>\u0234</p><!--l WITH CURL-->
<p>\u023D</p><!--L WITH BAR-->
<p>\u026B</p><!--l WITH MIDDLE TILDE-->
<p>\u026C</p><!--l WITH BELT-->
<p>\u026D</p><!--l WITH RETROFLEX HOOK-->
<reset>\u004D</reset><!--M-->
<p>\u006D</p><!--m-->
<p>\u0271</p><!--m WITH HOOK-->
<reset>\u004E</reset><!--N-->
<p>\u006E</p><!--n-->
<p>\u00D1</p><!--N WITH TILDE -->
<p>\u00F1</p><!--n WITH TILDE -->
<p>\u0143</p><!--N WITH ACUTE-->
<p>\u0144</p><!--n WITH ACUTE-->
<p>\u0145</p><!--N WITH CEDILLA-->
<p>\u0146</p><!--n WITH CEDILLA-->
<p>\u0147</p><!--N WITH CARON-->
<p>\u0148</p><!--n WITH CARON-->
<p>\u0149</p><!--n PRECEDED BY APOSTROPHE-->
<p>\u019D</p><!--N WITH LEFT HOOK-->
<p>\u019E</p><!--n WITH LONG RIGHT LEG-->
<p>\u01CB</p><!--N WITH SMALL LETTER J-->
<p>\u01F8</p><!--N WITH GRAVE-->
<p>\u01F9</p><!--n WITH GRAVE-->
<p>\u019D</p><!--N WITH LEFT HOOK-->
<p>\u019E</p><!--n WITH LONG RIGHT LEG-->
<p>\u01CB</p><!--N WITH SMALL LETTER J-->
<p>\u01F8</p><!--N WITH GRAVE-->
<p>\u01F9</p><!--n WITH GRAVE-->
<p>\u0220</p><!--N WITH LONG RIGHT LEG-->
<p>\u0235</p><!--n WITH CURL-->
<p>\u0272</p><!--n WITH LEFT HOOK-->
<p>\u0273</p><!--n WITH RETROFLEX HOOK-->
<reset>\u004F</reset><!--O-->
<p>\u006F</p><!--o-->
<p>\u00D2</p><!--O WITH GRAVE -->
<p>\u00D3</p><!--O WITH ACUTE -->
<p>\u00D4</p><!--O WITH CIRCUMFLEX -->
<p>\u00D5</p><!--O WITH TILDE -->
<p>\u00D6</p><!--O WITH DIAERESIS -->
<p>\u00D8</p><!--O WITH STROKE -->
<p>\u00F2</p><!--o WITH GRAVE -->
<p>\u00F3</p><!--o WITH ACUTE -->
<p>\u00F4</p><!--o WITH CIRCUMFLEX -->
<p>\u00F5</p><!--o WITH TILDE -->
<p>\u00F6</p><!--o WITH DIAERESIS -->
<p>\u00F8</p><!--o WITH STROKE -->
<p>\u014C</p><!--O WITH MACRON-->
<p>\u014D</p><!--o WITH MACRON-->
<p>\u014E</p><!--O WITH BREVE-->
<p>\u014F</p><!--o WITH BREVE-->
<p>\u0150</p><!--O WITH DOUBLE ACUTE-->
<p>\u0151</p><!--o WITH DOUBLE ACUTE-->
<p>\u019F</p><!--O WITH MIDDLE TILDE-->
<p>\u01A0</p><!--O WITH HORN-->
<p>\u01A1</p><!--o WITH HORN-->
<p>\u01D1</p><!--O WITH CARON-->
<p>\u01D2</p><!--o WITH CARON-->
<p>\u01EA</p><!--O WITH OGONEK-->
<p>\u01EB</p><!--o WITH OGONEK-->
<p>\u01EC</p><!--O WITH OGONEK AND MACRON-->
<p>\u01ED</p><!--o WITH OGONEK AND MACRON-->
<p>\u01FE</p><!--O WITH STROKE AND ACUTE-->
<p>\u01FF</p><!--o WITH STROKE AND ACUTE-->
<p>\u019F</p><!--O WITH MIDDLE TILDE-->
<p>\u01A0</p><!--O WITH HORN-->
<p>\u01A1</p><!--o WITH HORN-->
<p>\u01D1</p><!--O WITH CARON-->
<p>\u01D2</p><!--o WITH CARON-->
<p>\u01EA</p><!--O WITH OGONEK-->
<p>\u01EB</p><!--o WITH OGONEK-->
<p>\u01EC</p><!--O WITH OGONEK AND MACRON-->
<p>\u01ED</p><!--o WITH OGONEK AND MACRON-->
<p>\u01FE</p><!--O WITH STROKE AND ACUTE-->
<p>\u01FF</p><!--o WITH STROKE AND ACUTE-->
<p>\u020C</p><!--O WITH DOUBLE GRAVE-->
<p>\u020D</p><!--o WITH DOUBLE GRAVE-->
<p>\u020E</p><!--O WITH INVERTED BREVE-->
<p>\u020F</p><!--o WITH INVERTED BREVE-->
<p>\u022A</p><!--O WITH DIAERESIS AND MACRON-->
<p>\u022B</p><!--o WITH DIAERESIS AND MACRON-->
<p>\u022C</p><!--O WITH TILDE AND MACRON-->
<p>\u022D</p><!--o WITH TILDE AND MACRON-->
<p>\u022E</p><!--O WITH DOT ABOVE-->
<p>\u022F</p><!--o WITH DOT ABOVE-->
<p>\u0230</p><!--O WITH DOT ABOVE AND MACRON-->
<p>\u0231</p><!--o WITH DOT ABOVE AND MACRON-->
<reset>\u0050</reset><!--P-->
<p>\u0070</p><!--p-->
<p>\u01A4</p><!--P WITH HOOK-->
<p>\u01A5</p><!--p WITH HOOK-->
<p>\u01A4</p><!--P WITH HOOK-->
<p>\u01A5</p><!--p WITH HOOK-->
<reset>\u0051</reset><!--Q-->
<p>\u0071</p><!--q-->
<p>\u024B</p><!--q WITH HOOK TAIL-->
<reset>\u0052</reset><!--R-->
<p>\u0072</p><!--r-->
<p>\u0154</p><!--R WITH ACUTE-->
<p>\u0155</p><!--r WITH ACUTE-->
<p>\u0156</p><!--R WITH CEDILLA-->
<p>\u0157</p><!--r WITH CEDILLA-->
<p>\u0158</p><!--R WITH CARON-->
<p>\u0159</p><!--r WITH CARON-->
<p>\u0210</p><!--R WITH DOUBLE GRAVE-->
<p>\u0211</p><!--r WITH DOUBLE GRAVE-->
<p>\u0212</p><!--R WITH INVERTED BREVE-->
<p>\u0213</p><!--r WITH INVERTED BREVE-->
<p>\u024C</p><!--R WITH STROKE-->
<p>\u024D</p><!--r WITH STROKE-->
<p>\u027C</p><!--r WITH LONG LEG-->
<p>\u027D</p><!--r WITH TAIL-->
<p>\u027E</p><!--r WITH FISHHOOK-->
<reset>\u0053</reset><!--S-->
<p>\u0073</p><!--s-->
<p>\u015A</p><!--S WITH ACUTE-->
<p>\u015B</p><!--s WITH ACUTE-->
<p>\u015C</p><!--S WITH CIRCUMFLEX-->
<p>\u015D</p><!--s WITH CIRCUMFLEX-->
<p>\u015E</p><!--S WITH CEDILLA-->
<p>\u015F</p><!--s WITH CEDILLA-->
<p>\u0160</p><!--S WITH CARON-->
<p>\u0161</p><!--s WITH CARON-->
<p>\u0218</p><!--S WITH COMMA BELOW-->
<p>\u0219</p><!--s WITH COMMA BELOW-->
<p>\u023F</p><!--s WITH SWASH TAIL-->
<reset>\u0054</reset><!--T-->
<p>\u0074</p><!--t-->
<p>\u0162</p><!--T WITH CEDILLA-->
<p>\u0163</p><!--t WITH CEDILLA-->
<p>\u0164</p><!--T WITH CARON-->
<p>\u0165</p><!--t WITH CARON-->
<p>\u0166</p><!--T WITH STROKE-->
<p>\u0167</p><!--t WITH STROKE-->
<p>\u01AB</p><!--t WITH PALATAL HOOK-->
<p>\u01AC</p><!--T WITH HOOK-->
<p>\u01AD</p><!--t WITH HOOK-->
<p>\u01AE</p><!--T WITH RETROFLEX HOOK-->
<p>\u01AB</p><!--t WITH PALATAL HOOK-->
<p>\u01AC</p><!--T WITH HOOK-->
<p>\u01AD</p><!--t WITH HOOK-->
<p>\u01AE</p><!--T WITH RETROFLEX HOOK-->
<p>\u021A</p><!--T WITH COMMA BELOW-->
<p>\u021B</p><!--t WITH COMMA BELOW-->
<p>\u0236</p><!--t WITH CURL-->
<p>\u023E</p><!--T WITH DIAGONAL STROKE-->
<reset>\u0055</reset><!--U-->
<p>\u0075</p><!--u-->
<p>\u00D9</p><!--U WITH GRAVE -->
<p>\u00DA</p><!--U WITH ACUTE -->
<p>\u00DB</p><!--U WITH CIRCUMFLEX -->
<p>\u00DC</p><!--U WITH DIAERESIS -->
<p>\u00F9</p><!--u WITH GRAVE -->
<p>\u00FA</p><!--u WITH ACUTE -->
<p>\u00FB</p><!--u WITH CIRCUMFLEX -->
<p>\u00FC</p><!--u WITH DIAERESIS -->
<p>\u0168</p><!--U WITH TILDE-->
<p>\u0169</p><!--u WITH TILDE-->
<p>\u016A</p><!--U WITH MACRON-->
<p>\u016B</p><!--u WITH MACRON-->
<p>\u016C</p><!--U WITH BREVE-->
<p>\u016D</p><!--u WITH BREVE-->
<p>\u016E</p><!--U WITH RING ABOVE-->
<p>\u016F</p><!--u WITH RING ABOVE-->
<p>\u0170</p><!--U WITH DOUBLE ACUTE-->
<p>\u0171</p><!--u WITH DOUBLE ACUTE-->
<p>\u0172</p><!--U WITH OGONEK-->
<p>\u0173</p><!--u WITH OGONEK-->
<p>\u01AF</p><!--U WITH HORN-->
<p>\u01B0</p><!--u WITH HORN-->
<p>\u01D3</p><!--U WITH CARON-->
<p>\u01D4</p><!--u WITH CARON-->
<p>\u01D5</p><!--U WITH DIAERESIS AND MACRON-->
<p>\u01D6</p><!--u WITH DIAERESIS AND MACRON-->
<p>\u01D7</p><!--U WITH DIAERESIS AND ACUTE-->
<p>\u01D8</p><!--u WITH DIAERESIS AND ACUTE-->
<p>\u01D9</p><!--U WITH DIAERESIS AND CARON-->
<p>\u01DA</p><!--u WITH DIAERESIS AND CARON-->
<p>\u01DB</p><!--U WITH DIAERESIS AND GRAVE-->
<p>\u01DC</p><!--u WITH DIAERESIS AND GRAVE-->
<p>\u01AF</p><!--U WITH HORN-->
<p>\u01B0</p><!--u WITH HORN-->
<p>\u01D3</p><!--U WITH CARON-->
<p>\u01D4</p><!--u WITH CARON-->
<p>\u01D5</p><!--U WITH DIAERESIS AND MACRON-->
<p>\u01D6</p><!--u WITH DIAERESIS AND MACRON-->
<p>\u01D7</p><!--U WITH DIAERESIS AND ACUTE-->
<p>\u01D8</p><!--u WITH DIAERESIS AND ACUTE-->
<p>\u01D9</p><!--U WITH DIAERESIS AND CARON-->
<p>\u01DA</p><!--u WITH DIAERESIS AND CARON-->
<p>\u01DB</p><!--U WITH DIAERESIS AND GRAVE-->
<p>\u01DC</p><!--u WITH DIAERESIS AND GRAVE-->
<p>\u0214</p><!--U WITH DOUBLE GRAVE-->
<p>\u0215</p><!--u WITH DOUBLE GRAVE-->
<p>\u0216</p><!--U WITH INVERTED BREVE-->
<p>\u0217</p><!--u WITH INVERTED BREVE-->
<p>\u0244</p><!--U BAR-->
<reset>\u0056</reset><!--V-->
<p>\u0076</p><!--v-->
<p>\u01B2</p><!--V WITH HOOK-->
<p>\u01B2</p><!--V WITH HOOK-->
<reset>\u0057</reset><!--W-->
<p>\u0077</p><!--w-->
<p>\u0174</p><!--W WITH CIRCUMFLEX-->
<p>\u0175</p><!--w WITH CIRCUMFLEX-->
<reset>\u0058</reset><!--X-->
<p>\u0078</p><!--x-->
<reset>\u0059</reset><!--Y-->
<p>\u0079</p><!--y-->
<p>\u00DD</p><!--Y WITH ACUTE -->
<p>\u00FD</p><!--y WITH ACUTE -->
<p>\u00FF</p><!--y WITH DIAERESIS -->
<p>\u0176</p><!--Y WITH CIRCUMFLEX-->
<p>\u0177</p><!--y WITH CIRCUMFLEX-->
<p>\u0178</p><!--Y WITH DIAERESIS-->
<p>\u01B3</p><!--Y WITH HOOK-->
<p>\u01B4</p><!--y WITH HOOK-->
<p>\u01B3</p><!--Y WITH HOOK-->
<p>\u01B4</p><!--y WITH HOOK-->
<p>\u0232</p><!--Y WITH MACRON-->
<p>\u0233</p><!--y WITH MACRON-->
<p>\u024E</p><!--Y WITH STROKE-->
<p>\u024F</p><!--y WITH STROKE-->
<reset>\u005A</reset><!--Z-->
<p>\u007A</p><!--z-->
<p>\u0179</p><!--Z WITH ACUTE-->
<p>\u017A</p><!--z WITH ACUTE-->
<p>\u017B</p><!--Z WITH DOT ABOVE-->
<p>\u017C</p><!--z WITH DOT ABOVE-->
<p>\u017D</p><!--Z WITH CARON-->
<p>\u017E</p><!--z WITH CARON-->
<p>\u01B5</p><!--Z WITH STROKE-->
<p>\u01B6</p><!--z WITH STROKE-->
<p>\u01C5</p><!--Z WITH CARON-->
<p>\u01B5</p><!--Z WITH STROKE-->
<p>\u01B6</p><!--z WITH STROKE-->
<p>\u01C5</p><!--Z WITH CARON-->
<p>\u0224</p><!--Z WITH HOOK-->
<p>\u0225</p><!--z WITH HOOK-->
<p>\u0240</p><!--z WITH SWASH TAIL-->
</rules>
</collation>
</charset>



Edited 2 time(s). Last edit at 06/30/2008 11:23AM by R S.

Options: ReplyQuote


Subject
Written By
Posted
Custom utf8 Collation
R S
June 30, 2008 11:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.