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/2e972a09571fdbd3/926f4459a4daa8d9#926f4459a4daa8d9
> 
> 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.it MUSIC: 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+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Reply via email to