Hi. I just installed MySQL 4.1.20 for the UTF-8 support it offers. I'm
trying to set the charcter set & collation at the database level but
can't get it to work.
It works by setting it at the server level (in my.cnf) but I want to
set it at the database level because I'll be hosting the web app on a
third-party web hosting server, where likely I won't have access to
server level settings via my.cnf (is there a way around this?).
I perform the following query:
ALTER DATABASE <my schema name> DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
After the query a dump of the relevant MySQL variables is as follows:
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
collation_connection: utf8_general_ci
collation_database: utf8_general_ci
collation_server: latin1_swedish_ci
The variables look right but the characters (chinese in this case) do
not display correctly in the web page. As mentioned before setting the
charset at server level results in the characters displaying just fine.
Any thoughts/guesses?
Thanks in advance.
_____________________________________
Consolidate your email!
http://www.fusemail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
