class DATABASE_CONFIG { var $default = array( 'driver' => 'mysql', ... 'encoding' => 'utf8' ); }
I forget to put that in on a regular basis and it always costs my a few minutes of debugging. ;-) Not sure why it's not in the default template. On 6 Oct 2008, at 10:24, Ryan wrote: > > Hey Adam, thanks. Here's how I'm setup: > > core.php > Configure::write('App.encoding', 'UTF-8') > > database.php > (I don't see a place to specify UTF-8) > > MySQL > utf8_general_ci > > default.ctp (head section) > <?php echo $html->charset('UTF-8') ?> > > Am I missing anything? > > When you say to make sure all of my code is utf8 compliant (eg string > conversions), what do you mean? Can you be more specific? > > I think users of my site are entering curly quotes, which are saved to > the db, then come out as garbage when displayed in HTML. > > -Ryan > > > On Sep 30, 9:05 pm, Adam Royle <[EMAIL PROTECTED]> wrote: >> If your database is correctly setup as utf8, cakephp db settings as >> utf8 and your html is output as utf8, and make sure all of your code >> is utf8 compliant (eg string conversion, etc) then you shouldn't have >> any issues. Unless you just don't like the look of curly quotes? >> >> Cheers, >> Adam >> >> On Oct 1, 8:39 am, Ryan <[EMAIL PROTECTED]> wrote: >> >>> I'm using a UTF-8 character set and the curly single and double >>> quotes >>> are causing some problems with my app. I have a couple of questions >>> regarding the best way to deal with (eliminate) them: >> >>> Allow the curly quotes to go into the database, but convert them to >>> straight quotes before display? Or convert them into straight quotes >>> before going into the database? >> >>> And beyond that fundamental issue, what is the best way to convert >>> from curly to straight? I've dealt with similar issues in some of my >>> non-Cake PHP applications and am wondering if Cake has any built-in >>> functionality for dealing. >> >>> Thanks! > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---