A TEXT type of db field would be a better option for this...

2009/7/15 rich...@home <richardath...@gmail.com>

>
> "What kind of field are you using to store HTML?"
>
> As your new to MySQL its worth emphasising that text fields with the
> datatype of varchar have a maximum length. Your data may be getting
> truncated as it's too long to fit in the varchar field.
>
> Have you tried increasing the size of the field in the database to a
> larger value?
>
> On Jul 15, 3:30 pm, Piotr Kilczuk <kilc...@gmail.com> wrote:
> > Hello,
> >
> >
> >
> >
> >
> > > I am having a problem saving html code to a MySQL field using the
> > > saveAll method.
> >
> > > Basically what is happening is that only half of the html is actually
> > > saved at times depending on the content. At other times it works fine.
> > > When the body is comprised of text everything works perfectly
> > > everytime. This tells me that the code is in order for saving etc, the
> > > problem must be with certain html entities.
> >
> > > The code is extracted from html formatted emails (body).
> >
> > > Being new to ... wait for it ... PHP, CakePHP and MySQL this is a
> > > challenge as I have googled and yahood and read the manual been
> > > through the API code and to no avail ...
> >
> > > Humbly I ask for any assistance that anyone may provide, I am not sure
> > > if I should be running a function against the html prior to saving,
> > > and then again possibly when I want to display it (important to note
> > > that I require the original html to be viewed by a user at a later
> > > stage)
> >
> > What kind of field are you using to store HTML?
> >
> > Regards,
> > Piotr
> >
>

--~--~---------~--~----~------------~-------~--~----~
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