Re: Two in one: Accented letters and partially active debug

It sounds like your database table is latin_swedish_ci, but you have stored UTF-8-encoded data in it. I concur with euromark's recommendation to change your database tables' encoding to UTF-8, but you'll have to take special care to convert the encoding of all your existing data properly without messing it up (unless your existing data is only test data in which case just truncate it and make new test data).

On May 5, 2011, at 07:07, Mariano C. wrote:

> Data in DB is stored as latin_swedish_ci.
>
> On 5 Mag, 00:13, euromark <dereurom...@googlemail.com> wrote:
>> 1) @ryan: the other way around. encoding of the DB is probably wrong
>> (not utf8)
>>
>> 2) globally: debug 0 - in this particular action:
>> Configure::write('debug', 2);
>>
>> On 5 Mai, 00:02, Ryan Schmidt <google-2...@ryandesign.com> wrote:
>>
>>> On May 4, 2011, at 16:55, Mariano C. wrote:
>>
>>>> 1) when I insert data inside DB through a form, it will be stored as:
>>>> "This letters è is è and this l’ is an apostrophe "
>>
>>>> If I try to edit this text trough proper editing form, all of this
>>>> strange characters will be represented in right way as: è and '.
>>>> What can I do to proper echo the text even not in HTML form?
>>
>>> Hard to know exactly what's happening without more info. One possibility is that the data is being stored correctly as UTF-8, but then when you are displaying it, you're on a page with encoding ISO-8859-1; the solution would be to ensure your pages are using UTF-8 encoding.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

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