PHP 4.0 Bug #6534 Updated: problem while inserting accented character whith OCI

ID: 6534 Updated by: thies Reported By: guenault@cstech.fr Status: Closed Bug Type: Oracle related Assigned To: Comments: please set your NLS_LANG to something meaningful in your apache startup script. Previous Comments: [2000-09-04 14:27:08] guenault@cstech.fr 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 ! --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=6534