Re: Correct Way to save HTML code to database

2009-07-15 Thread Jacques
Hi All, I came right thanks - the problem was the character set being read in not being utf-8 a simple php mb_convert solved the problem. Cheers J On Jul 15, 9:18 am, Jacques wrote: > Hi There, > > I am having a problem saving html code to a MySQL field using the > saveAll method. > > Basicall

Re: Correct Way to save HTML code to database

2009-07-15 Thread christo
this could be any number of things. Where is the html from? I'd examine the source first, to make sure that's not the problem. Second, i'd test out the html that gives you a problem. Where is it cutting off? Do you run html_entities, or real escape on it before you insert? If it was an html entity

Re: Correct Way to save HTML code to database

2009-07-15 Thread Carlos Gonzalez Lavin
A TEXT type of db field would be a better option for this... 2009/7/15 rich...@home > > "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

Re: Correct Way to save HTML code to database

2009-07-15 Thread rich...@home
"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 th

Re: Correct Way to save HTML code to database

2009-07-15 Thread Piotr Kilczuk
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 per

Correct Way to save HTML code to database

2009-07-15 Thread Jacques
Hi There, 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 e