On Wed, 1 Dec 2004 14:16:40 +0100 Sergei Golubchik <[EMAIL PROTECTED]> wrote:
> > character_set_client = A > > character_set_connection = B > > character_set_database = C > > character_set_results = D > > character_set_server = E > > character_set_system = F > > F is always utf8 > > > a table named table = G > > a column named column = H > > > > client sends to the server a string in A charset. > Parser converts identifiers (strings 'table', 'column') to F if they > contain non-ascii characters. > > MySQL returns the result (column) to the client, converting from H > to A. > > > Which character sets must be equal (or convertable to each other) > > for this query to run properly? > > where clause looks like (charset-wise) > > [H] = [F] and [H] like [A] > > so you should be able to compare strings in charsets H and F, and > H and A. Explicit casting will always help, of course: > > WHERE CONVERT(column, USING utf8) = USER() ... > > Regards, > Sergei Ok, I think now I understand most of the things, except, what effect has the character_set_connection (B), and character_set_server (E)? Doesn't the server returns the results in D if it differs from A? Thanks! -- DÃmsÃdi Gergely / UHU-Linux Kft. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]