On Tue, 20 Apr 2004 12:13:07 -0500, Paul DuBois wrote: > At 13:03 -0400 4/20/04, Stormblade wrote: >> On Tue, 20 Apr 2004 11:49:46 -0500, Paul DuBois wrote: >>>>> Make sure the server really is picking up the option value: >>>>> >>>>> >>>>> SHOW VARIABLES LIKE 'character%'; >>>>> >>>>> >>>>> Look for 'character_set_server'. >>>>> >>>>> >>>>> If it's utf8, then perhaps your GUI tools are overriding >>>>> the setting? Dunno. You might try creating a database >>>>> through the GUI and then looking at the server query log to >>>>> see what query is actually being sent to it. >>>>> >>>> >>>> Using WinMySQLadmin 1.4 which came bundled with it I viewed >>>> the variables and it >>>> seems that it's not picking it up. The variable you mention >>>> is still set to latin1. Adding that line you mentioned didn't >>>> change anything. Is there a different format for the ini file >>>> on *Nix vs Windows? >>>> >>> >>> No. But you're asking me to guess what you did. What file did >>> you add the lines to, and what lines did you add? Did you >>> restart the server? >>> >> >> The file was my ini file. my.ini which is located in the windows >> directory. I copy and pasted the line you gave here and put it >> under the [mysqld] section in that ini file. Yes I restarted the >> server. >> > > Hmm. That should have done it. There weren't any messages in the > error log about the server not liking the option or anything?
If by error log you mean the mysql.err file in the data subdirectory then no it shows only normal connections and shutdowns. No errors. >>> >>> >>>> Here's my variables: >>>> >>>> >>>> character_set_server: latin1 >>>> character_set_system: utf8 >>>> character_set_database: latin1 >>>> character_set_client: latin1 >>>> character_set_connection: latin1 >>>> character_set_results: latin1 -- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) "The worth of your opinion is in direct proportion to the number of people who have asked for it." My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
