Database Administration (MOSC)

MOSC Banner

I have a problem of NLS_LANG with my client 10.2.0.4

edited Apr 4, 2011 9:16PM in Database Administration (MOSC) 5 commentsAnswered
 hello,      I have a problem with my client Oracle 10.2.0.4, jdbc or sqlnet.
When I execute on my database a query from my client in french_FRANCE the sort of my query is different of the result of my client in english_AMERICAN. My database is in NLS_LANG  American_america.utf8
I would like obtain the same result from my sort.
What are the parameters of client or of my database to obtain the same result ?

Who can help me ?
JP

the query is :
select * from WTRUN2.XX_LIENARTICLEDOC_PURCHASE
WHERE NUMERO_ARTICLE = 'CCA2212' and VERSION_ARTICLE = 'Q.A.1';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center