PHP 4.0 Bug #6534: problem while inserting accented character whith OCI
| From: | guenault at cstech dot fr | Date: | Mon, 04 Sep 2000 18:27:08 +0000 |
| Subject: | PHP 4.0 Bug #6534: problem while inserting accented character whith OCI | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-31959@lists.php.net to get a copy of this message | ||
From: guenault@cstech.fr
Operating system: Sun OS 5.7
PHP version: 4.0.2
PHP Bug Type: Oracle related
Bug description: problem while inserting accented character whith OCI
First Problem :
I try to insert accented characters values into a table using OCI and PHP4.0.2
the characters é became i , è became h ...etc.....
When i do the same query using sql+ there are no problem
- this problem have been solved using htmlentities to convert accented chars to html and decoded
in oracle using a stored procedure.
Second problem :
When i maque a select query on values that are accented, accent desapear : for exemple
"résumé" is stored in the table and the query return "resume"
Do you have ever heard about this problem ?
Thanks a lot you make a very good job !