• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

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.
0
mfloryan
Asked:
mfloryan
1 Solution
 
Richard QuadlingSenior Software DeverloperCommented:
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
 
Computer101Commented:
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now