"Tumurbaatar S." <[EMAIL PROTECTED]> wrote:
> I'm running MySQL 3.23.55 on WinXP and
> have some problem using non latin charset.
> I've added these 2 lines under [mysqld] group
> of my.ini:
>
> character-sets-dir = c:/mysql/share/charsets/
> default-character-set=cp1251
>
> Then restarted server and created a simple database
> with a string fields. 'myisamchk' utility shows that
> tables in above db have cp1251 charset.
> After I used some PHP page to insert a few records
> with a russian cyrillic and english texts into the db table.
> But SELECTing back them with a char case conversion
> (UPPER(),LOWER(),UCASE(),LCASE()) failed.
> All english texts were correctly converted, but russian
> strings had only 3-4 char-s (from total 33 letters) converted
> and other char-s had original case. I tried a simple select:
>
> SELECT UPPER('...all russian/win1251 lower letters...');
> or
> SELECT LOWER('...all russian/win1251 upper letters...');
>
> They returns almost same strings exept of 3-4 letters
> correctly case converted. Other ones remain intact.
> Also I have mixed russian and english letters like:
>
> SELECT UPPER('... russian/win1251 lower letters plus some english
> char-s...');
>
> In result, the english char-s were converted correctly but russian had
> same problem.
>
> What did I do wrong in using non default charset?
Hmm .. I tested on my Win box with MySQL 4.0.14 and both functions LOWER() and UPPER()
worked like a charm with cp1251. Show me exactly queries which are wrong for you.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
