This is indeed weird. I'd recommend you check the source of one of your generated pages from a browser and make sure that the charset is correctly defined, it should look like this: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
And make sure you set encoding: utf8 in your databases.yml. It's really essential or else your pages will use a different charset than your MySQL connection. And if you really can't work it out, you should probably just change everything to iso8859-1 and see how it works out (but you can keep your tables as UTF-8, because MySQL performs on-the-fly conversion between the client connection and the tables). On 11/26/07, Jonotron <[EMAIL PROTECTED]> wrote: > > I've built a web app for our teachers (Canada), some of them need to > input French characters. > > When they try to input accent characters (like in Fran�ias) the french > characters get replaced with a funny ? symbol in the database (MySQL > 5.0). > > After looking through the group and forum I've tried the following (in > this order): > * update my_table set my_column = 'Fran�ias' where id = 123; This > works and the french characters are put in correctly and are retrieved > correctly so I don't think it's the database. > * altered the table and column to UTF8 (from western-european); this > seems to make no difference > * set charset: utf-8 in my settings.yml file; this seems to make no > difference > * set encoding: utf8 in my databases.yml file; this causes the french > character and any character after it to be truncated from the form > insert. Also if I update a record manually using a SQL query the data > returned looks strange Fran�ias is displayed as Françias - this > behaviour makes me think it is a charset issue. > > I have no idea what to do about this, but it is becoming a concern of > my users. > > Any help would be appreciated. > > > > -- - SR --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---