Re: Persian Collation Support in MySQL

[Alexander Barkov]

Hello Ali,

Ali Majdzadeh wrote:

 > Hello Mr.Barkov
 > Thanks for your patience.
 >
 > I have tried Jody's patch and corrected some of
 > my errors,but I can not change the default collation
 > to "utf8_persian_ci".

There are several ways:

1. Run "configure --with-charset=utf8 --with-collation=utf8_persian_ci",
    then make.

2. Start:
mysqld --default-character-set=utf8 --default-collation=utf8_persian_ci

3. Or, create a database with Persian collation:

CREATE DATABASE db CHARACTER SET utf8 COLLATE utf8_persian_ci;


> Every time I try to change it,
> the previous one still remains.

What do you mean the previous remains?  How does it look like?
I need step-by-step instruction explaining what you're
trying to do to give a better answer.

> I don't know where I go wrong in compilation.

What does this query return for you:

SHOW VARIABLES LIKE 'collation%';

> Any suggestions?
> Regards
> Ali
>

Regards!