Re: Single quotes in INSERT statements?
| From: | Skip Evans | Date: | Tue, 25 Apr 2006 21:10:26 +0000 |
| Subject: | Re: Single quotes in INSERT statements? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41746@lists.php.net to get a copy of this message | ||
Martin Alterisio wrote:
1) Check that the string is not being truncated because of the column lengthThis was not it.
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.
3) ..... dunnoSee number 2 ;) Thanks again! -- Skip Evans Big Sky Penguin, LLC 61 W Broadway Butte, Montana 59701 406-782-2240