On Saturday 04 January 2003 21:07, Paul Reilly wrote: > I have a website which gets data from MySQL. The website is in several > languages. I'm now working on Russian, and we have the translations, but > I can't seem to get it into MySQL. > > I have a few questions which I hope someone can help with: > > 1) I see from research I must run another instance of MySQL > to be able to work in russian. Is this correct? > > 2) What is the best character set to use? > Will UTF-8 work? > > 3) How to best enter russian text strings using an english locale?
For Russian language win1251 (cp1251 in MySQL) or koi8-r encodings are used. You can store data in Russian language with other data as well. The problem is that you may get incorrect result in search and ordering. If gonna store Russian data in win1251 you can define your columns as BINARY. UTF-8 will be supported only since version 4.1. -- 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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
