hi all,

I'm facing problem while searching with a string which contains some spanish character.

In our pre production server, when we are searching in a schema with field1 ='LII TestingRecord - manándar', resulting rcord is having field1= 'LII TestingRecord - manandar'.

Internally its converting the string 'LII TestingRecord - manándar' to ''LII TestingRecord - manandar' and retrieving the result.

But in our production server its not able to convert the string from 'LII TestingRecord - manándar' to ''LII TestingRecord - manandar'

I tried setting the same locale in both the server. Both the server have same version, patch number , DBVERSION in control table , Database Version.

Can anyone please point out why it is behaving differently?

Is there configuration change i need to do?

Thakns and Regards,
KSP

Hi,

Did you check the NLS paramaters of both databases?
Did you check the characterset of both databases?

hi,

NLS parameters and Characterset of both the databases are same.

Any idea what might be the reason?

Regards,
KSP

What about client locale and version? It's the same when you try to perform serach on both server?

locale and version of client tool are also same.We tried logging in both server in the same window. locale En_GB and client version 5.01.02 Patch 1350.

Regards,
KSP

Quite amazing...

Are the locale of both server OS the same?

Can you please let me know how to check that?

Regards,
KSP

On Windows it is: Control Panel --> Regional and Language Options
On Unix (I think) it is: locale -a

i did locale -a and found the same result in both the server, we compared two result sets and those are identical.

Then i check env for both the server. here a small discrepency we found was --
in one server (where the problem does not exists) NLS_LANG parameter is set, which is not the case in other server (where the problem exists).

Do you think this can be the problem?

Regards,
KSP

What is the NLS_LANG Value?
$ echo $NLS_LANG