SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work
I made a new Query, copying the text as you wrote it, and it still
didn't work, but in a different way.
I type:
SET collation_connection = utf8_general_ci;
... and I get the following returned to me:
Your SQL-query has been executed successfully (Query took 0.0002 sec)
But, when I type:
SHOW VARIABLES;
... it still shows:
collation_connection latin1_swedish_ci
Am I perhaps setting the variable in the wrong place? Globally and not
locally or something to that effect?
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]