php, oracle and ascii characters
| From: | Dan Christie | Date: | Fri, 09 Nov 2001 03:45:55 +0000 |
| Subject: | php, oracle and ascii characters | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14171@lists.php.net to get a copy of this message | ||
We are creating a content management system for a web site. In this app,I am
filling the contents of an html text area with the contents of a field in an
oracle database. This is our dynamic content for the site.The text area
allows the user to update its contents. For the time being, any characters
oracle considers illegal were to be entered by the client manually in their
ascii form. For instance, ' will be '. We thought this would be a short
term solution allowing the browser to see the characters correctly, and the
database to not error on the update.
The content can be saved to the database correctly, but when it is retrieved
there seems to be a conversion going on. I am seeing the character
interpreted as \' causing the next update on this field to fail. It is
strange because when I view the source, the html correctly keeps the ',
but when I use it in a php string and send it to the database, it seems to
be making a switch.
I need to keep this consistantly in its ascii representation, except when it
is viewed in a browser.
Thanks, I'm desparate!
Dan