Then Cake might be trying to save utf8 to the "latin" database and
converting the data for you at some stage.
Come to think of it... is the problematic data being saved to the db?
Can you check the contents of the database directly?
Cake might be converting the encoding at the output of the dump.
As a rule, when you have the db, Cake or the html set to a different
character encoding than the others you will see strange things with
non-latin characters. (then again, the minus-sign should be generic
enough to pass untouched).
Sorry, just ramblings. I havent investigated the details. I just
figured I'd better set everything to the same encoding to avoid
further problems (and oh boy did I have problems at one point).
On Jul 9, 3:02 pm, Ernesto <e.fanz...@gmail.com> wrote:
> Hi Martin.
>
> i really appreciated your hints.
>
> here's my findings
> - I coded an "echo '----';" in the non-working layout --> the dashes
> are correctly printed.
> - I coded another "echo '----';" in one of the non-working views -->
> the dashed are still correctly printed
> - The data is auto-filled by the controller, this app has no forms
> - all 5 views are using the same DB Connection and the same Database
> - the SQL Connection, the DB and all the DB's tables have the same
> collation ("latin1_swedish_ci")
> - all the DateTime fields has no collation selected
> - Cake app has UTF-8 encoding
>
> the problem is still here :(
>
> On 9 Lug, 11:54, Martin Westin <martin.westin...@gmail.com> wrote:
>
>
>
> > Did I get this right:
> > This problem is with datetime-fields when one of your layouts is used
> > bit not the other.
>
> > The problem looks a bit like an encoding problem (utf8/latin1) of some
> > kind. I try to make sure that html layouts, Cake's app encoding, sql
> > connection, database, tables and fields... in short: everything uses
> > the same encoding.
>
> > if you pr (or debug) the data, it will still be output to the browser
> > and to be sure the dashes (minuses) are ok you need to look at the
> > source of the html output.
>
> > You should start by looking at the form (the data is from a form?)
> > before posting. Does the problem-layout output the dashes ok?
> > Look at the html head for encoding info, compare to any encoding
> > headers sent (using Firefox, Developer extension).
> > Compare that to the working layout.
>
> > Then work your way back towards the model. Check in the controller,
> > then the Model. Hopefully you will find where thing do crazy.
>
> > My guess is either in the initial output to the form, or in the post
> > back to Cake.
>
> > On Jul 9, 11:05 am, Ernesto <e.fanz...@gmail.com> wrote:
>
> > > i still haven't find a solution...
>
> > > i pr-ed $this->data in model::beforeSave.
>
> > > everything looks correct.
>
> > > this could be a MySQL-related issue :(
>
> > > On 8 Lug, 17:18, Ernesto <e.fanz...@gmail.com> wrote:
>
> > > > this app is a very simple app. It is composed by a single controller,
> > > > two layouts and 5 views.
> > > > there's no app_controller or app_model and even no behaviors.
> > > > i'm having this problem on the last 2 views, both using the second
> > > > ("striptothebone") layout.
> > > > The other 3 views are working fine.
> > > > Every views saves one DateTime.
>
> > > > On 8 Lug, 16:48, Robert P <shiftyrobs...@gmail.com> wrote:
>
> > > > > There are a lot of resulting steps between you passing in your data
> > > > > and the resulting SQL being queried. Please provide some more
> > > > > information and code examples.
>
> > > > > On Jul 8, 9:33 pm, Ernesto <e.fanz...@gmail.com> wrote:
>
> > > > > > DateTime
> > > > > > default = null
> > > > > > null field
>
> > > > > > On 8 Lug, 15:20, Alastair <m...@alastairmoore.com> wrote:
>
> > > > > > > On Jul 8, 2:15 pm, Ernesto <e.fanz...@gmail.com> wrote:
>
> > > > > > > > Hello.
>
> > > > > > > > i'm having some troubles with cake.
>
> > > > > > > > here's my this->data array
>
> > > > > > > > Array(
> > > > > > > > [id] = 30
> > > > > > > > [date] = 2009-11-23
> > > > > > > > )
>
> > > > > > > > here's a piece of my SQL dump
>
> > > > > > > > UPDATE `table` SET `id` = 30, `date` = '2009-11-23'
> > > > > > > > WHERE
> > > > > > > > `table`.`id` = 30
>
> > > > > > > > why is cake de-coding the "-" in date???
>
> > > > > > > Is the "date" field definitely a date or datetime type in your
> > > > > > > database?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
