Hello.
> How to create the default? Put the following line into [mysqld] section of your config file: default_character_set=utf8 See: http://dev.mysql.com/doc/mysql/en/charset-defaults.html > I just upgraded from 4.0.8 to 4.1.9. After upgrading, some times it is necessary to do additional actions. See: http://dev.mysql.com/doc/mysql/en/charset-upgrading.html > I need to support french accents. Right now, not sure if it's MySQL or PHP. > But all accented caracters in the database are coming out wrong. Send us the output of the following statements: show variables like '%char%'; show variables like '%coll%'; Check the character set in your browser. As I know, PHP takes the character set from the server. "Michael J. Pawlowsky" <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: ISO-8859-1, 23 lines --] > > I just upgraded from 4.0.8 to 4.1.9. > On MySql 4.1.9 my default collation seems to be latin1_swedish_ci. > > I need to support french accents. Right now, not sure if it's MySQL or PHP. > But all accented caracters in the database are coming out wrong. > > I'm thinking I should just use utf8_general_ci but have no idea what the > implications are. > Also I have no idea why latin1_swedish_ci.was chosen as my default. > > Does anyone have a good link of where I can read up more on choosing a > collation? > How to create the default? > > Or if you have a quick amswer for me that would be great. > Right now almost every 3rd word displays wrong. > > Thanks, > Mike > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
