At 13:26 2002-03-13, Victoria Reznichenko wrote: >Alex, >Wednesday, March 13, 2002, 7:16:02 PM, you wrote: > >AK> I'm very much interested to know how do you manage multiple language >support with >AK> mySQL. > >AK> I haven't found how i can define different character sets for >different tables or >AK> even for separate databases. > >AK> Do i have to run several mySQL servers, one per each charset? > >You can use only one character set at a time for one instance of >mysqld. If you want to use two character sets you need to restart >or start another instance of mysqld.
Is it something that someone is thinking about? Examples of it's use are abundant, to use a trivial one: my books. I have books in German, English, French, Polish, Russian and Czech. Obviously, they will require differing charsets to represent their titles and authors. As obviously, if I search for all the books on a specific subject, I want to find all I have, no matter which language they were published in. Single-charset restriction prevents me from doing that, I will have to perform as many searches as I have languages, wasting both time and resources: both at runtime and during development. Or am I completely out of my tree? -------------------------------------------------- sql, query --------------------------------------------------------------------- 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
