Thanks will get the host to look into. Unfortunately I don't have access to the server to make this change.
From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Pepperman Sent: Wednesday, October 28, 2009 2:32 PM To: [email protected] Subject: Re: [ACFUG Discuss] OT: MySQL Error Also check the mySql server collation . The default settings will always use latin1 latin1_swedish_ci unless the server collation is defined on startup. If you don't specify a character set, that is the same as saying <http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_ch aracter-set-server> --character-set-server=latin1. If you specify only a character set (for example, latin1) but not a collation, that is the same as saying <http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_ch aracter-set-server> --character-set-server=latin1 <http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_co llation-server> --collation-server=latin1_swedish_ci because latin1_swedish_ci is the default collation for latin1. http://dev.mysql.com/doc/refman/5.0/en/charset-server.html http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
