Re: [PHP] charset win1251

[BRACK]

Hi Maxim,

You are probably only one in this mailing list with experiance of 
work with russian language in PHP, I have another qwestion 
concerning Opera and textarea - I can't make Opera to accept 
cyrillic text in textareas, I mean I can type in Russian but can't 
insert russian text (tried various formats) into textarea in Opera. I 
have Russian Opera 5.12 and russificated Windows ME in settings 
of Opera all fonts are cyrillic, I have already 4 years experianse of 
working with Opera but actually never knew that it has such 
problem =(( I'm mostly worried about visitours of my site who use 
Opera, they will not be able to save data in database because they 
will have this prob with textarea. By the way texarea is working 
wonderfully with IE. and I tried to add different charsets and lang 
variables to textarea HTML-tag didn't work any way.

Youri

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] charset win1251

[Maxim Derkachev]

Hello BRACK,

Thursday, August 09, 2001, 10:19:46 PM, you wrote:
B I finished English version of my site and wanted to start Russian
B part but realized that MySQL server returnes all data in koi-8r 
B charset which is not very comfortable for some of the users, 
B specially I know that A LOT of russians using Opera brawser older 
B versions of which do not support koi-8 Any one knows how to 
B convert koi-8 results of MySQL to win1251? 

It depends. What charset is your data in?
If you DB's data is already in koi-8r, ther only thing you can do at the
database level is to use a query:
SET CHARACTER SET  koi8_cp1251
and then execute your queries.
All the data will be converted to win1251 codepage on the fly.
Alternately, you can place all the data to the database in 1251
charset, and then compile mysqld with option
--with-charset=cp1251 (used in ./configure)
Then you'll have all the data returned in cp1251, and mysql will sort
all the text data using that charset. To have the data returned in
koi-8 in this case you'll have to issue a query
SET CHARACTER SET  cp1251_koi8

By the way, there's not so many russians, if any, using the old Opera browsers
:)


-- 
Best regards,
Maxim Derkachev mailto:[EMAIL PROTECTED]
System administrator  programmer,
Symbol-Plus Publishing Ltd.
phone: +7 (812) 324-53-53
www.books.ru, www.symbol.ru 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]