Re: Single quotes in INSERT statements?
| From: | Martin Alterisio | Date: | Wed, 26 Apr 2006 02:30:40 +0000 |
| Subject: | Re: Single quotes in INSERT statements? | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41749@lists.php.net to get a copy of this message | ||
2006/4/25, Skip Evans <skip@bigskypenguin.com>:
>
> Martin Alterisio wrote:
> > 1) Check that the string is not being truncated because of the column
> length
> >
>
> This was not it.
I was sure it wasn't but the first rule of debugging says "never discard a
possible cause, no mather how dumb it may seem"
> 2) If you're seeing this data being truncated in the html output of your
> > site, check if it isn't being caused by outputing the data without
> > properly encoding special html characters.
> >
>
> Yup! This was it. The data was fine in the
> database, so I wrapped the output with
> htmlentities() and all came out good.
>
> Thanks to Martin and all who made suggestions.
You're welcome.
> 3) ..... dunno
>
> See number 2 ;)
>
> Thanks again!
>
> --
> Skip Evans
> Big Sky Penguin, LLC
> 61 W Broadway
> Butte, Montana 59701
> 406-782-2240
>