Re: UTF-8 Persian collation in 4.1.x

[Peter Cruickshank]

On Mon, 19 Jul 2004 22:41:21 +0200
Sergei Golubchik <serg@stripped> wrote:

> Hi!
> 
> On Jul 09, Peter Cruickshank wrote:

<snip>

> > My question is: is anyone working on adding Persian (Farsi) UTF-8
> > collation to MySql? If so, is there an estimate of when the work could
> > be done?
> 
> Nobody is working on it as far as I know.
> 
> Unfortunately it's it not very high in our todo - all the developers are
> busy with higher priority tasks.
> Though adding it is not very difficult, as MySQL already supports almost
> everything that is necessary. In particular within UCA framework one can
> easily define collations like (quoting from ctype-uca.c, MySQL sources)
> 
>   static const char czech[]=
>       "& C < \\u010D <<< \\u010C "
>       "& H <      ch <<<      Ch <<< CH"
>       "& R < \\u0159 <<< \\u0158"
>       "& S < \\u0161 <<< \\u0160"
>       "& Z < \\u017E <<< \\u017D";
> 
> For now contractions (like above) are only implemented for basic latin
> characters 'a'..'z'. It won't be difficult to extend the code to suport
> contractions for any unicode characters - then Persian collation would
> be possible.
> 
> If you're interested in doing it, we would be very glad to help with any
> information and guidance that would be necessary!

Thanks. One of us may well be in touch!

Peter

-- 
Peter Cruickshank, OpenConcept Consulting
Free Software for Social Change

peterc openconcept.ca