Thanks to Spark and AD7six for their kind help. I figured it out (big
part of the problem was in my local httpd.conf file). Let me just make
a summary so that everybody keep in mind when dealing with UTF-8
encoding:
How to display Portuguese encoding or general UTF8 encoding in Cake or
dynamic programming. Check that you have the following elements:
•httpd.conf: AddDefaultCharset UTF-8,
•Files must be saved with UTF-8 format (all your previous special
character are now unreadable and must be rewritten),
•Default.ctp: echo $html->charset('UTF-8'); (equivalent to <meta http-
equiv="Content-Type" content="text/html; charset=UTF-8" />),
•Headers should also display: <html xmlns="http://www.w3.org/1999/
xhtml" xml:lang="pt" lang="pt" dir="ltr">
•Database should be configured as utf8_unicode_ci for both tables and
fields.
That should work!
On 15 Jun, 17:56, Webrickco <[EMAIL PROTECTED]> wrote:
> Thx for your kind answers.
>
> The point is that everything looks fine locally and when i put
> everything on the server the Ajax request fail to present data
> properly, however requests to the database and HTML presentation
> continue to work fine in ISO-8859-1, and unfortunately not in UTF-8.
>
> I would believe this is a server configuration issue and will follow
> your recommendation on that matter.
>
> On 15 Jun, 15:49, Spark <[EMAIL PROTECTED]> wrote:
>
>
>
> > database default collation is just a little part, and doesn't matter
> > as much as you may think.
> > database connection is far more important (you can change it in
> > config/database.php), the file you are editing is, i'm almost for
> > sure, wrongly encoded. Try To change it in Aptana or Eclipse (under
> > the 'edit' menu, there's a 'set encoding' option. It's the most common
> > mistake when dealing with utf8. Another sensitive part is the *server*
> > configurations for sending text/html. Some of very old or badly
> > configured servers lack the possibility to send it in utf8, therefore,
> > breaking the path between cake and the browser.
>
> > This is *the* article to read. It helped me a thousand times when
> > dealing with 'i dont need to know this'
> > programmers:http://www.joelonsoftware.com/articles/Unicode.html
>
> > Spark
>
> > On Sun, Jun 15, 2008 at 6:33 AM, Webrickco <[EMAIL PROTECTED]> wrote:
>
> > > Hi, I have a problem figuring out why the result of an Ajax execution
> > > is not in the correct encoding under cake.
>
> > > You can see the result athttp://webrickco.com/caketest. Using the
> > > user/password david/test and clicking on the first link: "Alterar a
> > > configuração dos menus". At this point the result of the consultation
> > > to the database is correctly displayed as well as all other
> > > accentuated text in the page, but if I click on a tick button (calls
> > > an Ajax function to copy the values to the edit fields and refreshes
> > > the item list), the refresh of the DIV is compromised. How do i do to
> > > keep the correct encoding after I fire an Ajax function?
>
> > > Some data on the site:
> > > Default.ctp: $html->charset('ISO-8859-1');
>
> > > Ajax function triggered as follow:
> > > echo "<td>".$ajax->submit('tick.png', array('update' => 'tabela',
> > > 'loaded' => Effect.BlindDown(\'tabela\')', 'url' => '/menus/update/'.
> > > $menu['Menu']['id']."/".$menu['Menu']['description']."/".$menu['Menu']
> > > ['link']))."</td>";
>
> > > Database fields and tables are kept in utf8_general_ci encoding by
> > > default
>
> > > Thx for your help.
>
> > --
> > [livesets]http://djspark.com.br/
> > [web]http://sydi.net
> > [filmes]http://melhoresfilmes.com.br- Ocultar texto citado -
>
> - Mostrar texto citado -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
