Hello.
In most cases, if A,B,.. are in different charsets you'll get an error. Use SET NAMES, CONVERT() or CAST() functions, introduced to convert everything to the same single charset. Because in other case you'll get results converted to character_set_results, except it was set to NULL. May be you should think about unicode in your project. D?ms?di Gergely <[EMAIL PROTECTED]> wrote: > Hi! > > I've been digging through the web for a few days, but I didn't get any > answers for my little question, so I try to ask it here: > > For example I set the following character sets: > > character_set_client = A > character_set_connection = B > character_set_database = C > character_set_results = D > character_set_server = E > character_set_system = F > > a table named table = G > a column named column = H > > The question is: Exactly what character conversions will be done by the > mysqld, when i issue a statement like: > > SELECT column FROM table WHERE column = USER() and column like 'some > text in A encoding%'; > > Which character sets must be equal (or convertable to each other) for > this query to run properly? > > Thanks in advance! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
