Re: accents in html forms

i would not use utf8_general_ci
use utf8_unicode_ci instead!

the general one has major problems sorting!
if you want to return your results with ORDER BY some day you might
consider taking my advice :)

On 26 Dez., 11:20, Lorenzo Bettini <bett...@dsi.unifi.it> wrote:
> Thanks for the link!  I had searched through google but I hadn't found
> this one.
>
> These points are crucial
>
> 1. App.encoding must be UTF-8 (core.php)
> 2. Database encoding must be UTF8 (MySQL)
> 3. Database connection encoding must be UTF8 (database.php)
>
> in the core.php it was already UTF8
>
> I then added in database.php the line
>
> 'encoding' => 'utf8',
>
> and, most important, all my tables were sweedish encoding (why that's
> the default I wonder :) so I altered all the tables with
>
> ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8 COLLATE
> utf8_general_ci;
>
> I think this might be quite a recurrent problem, so why not put it into
> a FAQ?
>
> thanks again for your help
> cheers
>         Lorenzo
>
>
>
> Dr. Loboto wrote:
> > "A little bit more specific", UTF-8 checklist:
> >http://groups.google.com/group/cake-php/browse_thread/thread/2e972a09...
>
> > On Dec 24, 10:04 pm, Lorenzo Bettini <bett...@dsi.unifi.it> wrote:
> >> mh... could you please be a little bit more specific?
>
> >> thanks
> >>         Lore
>
> >> euromark wrote:
> >>> yes it is
> >>> use utf8 in your template files if you need to use special characters
> >>> On 24 Dez., 16:10, Lorenzo Bettini <bett...@dsi.unifi.it> wrote:
> >>>> Hi
> >>>> I'm experiencing problems with words with accents (e.g., Lu s) which are
> >>>> not displayed at all in html forms generated with the html form helper
> >>>> (e.g., select fields).
> >>>> Is this a problem with encoding?
>
> --
> Lorenzo Bettini, PhD in Computer Science, DI, Univ. Torino
> HOME:http://www.lorenzobettini.itMUSIC:http://www.purplesucker.com
> BLOGS:http://tronprog.blogspot.com http://longlivemusic.blogspot.com

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en