OCIResult and Spanish characters

I have a particular problem with Oracle9i running on  SUSE Linux 7.2 with Apache and PHP 4.0.6

The problem concerns Spanish national characters, that  is whenever I try to get a result of a SELECT
statement  by  means of PHP Oci functions (OCIResult)  in  stead  of  some characters I get question marks (?) and also accents are always stripped. The same doesn't happened if I access the database from outside the linux machine.
mfloryanAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed, with points refunded (50)

Computer101
E-E Admin
0
 
Richard QuadlingSenior Software DeveloperCommented:
Is the browser mis-drawing them. Do you need to set the language for the browser?
0
 
mfloryanAuthor Commented:
OK. The problem is NOT in the browser the problem was in the linux server. The NLS_LANG variable was not correctly set for the apache server environment. Now everything works well, but another problems arise. However they concern PHP itself.
0
 
LornaJaneCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
deleted and the points refunded
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

LornaJane
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.