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 <doome@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
