-
Hi all, my Oracle database is 8.1.6 and it was created in standard US7ASCII and I have just converted it to UTF8. All the data in the server is in english. Now the user must be able to view/add/update the data in spanish or english depending on the requirement from the front end. Do I have to use a middle layer with a user defined data map which does the transition between spanish & english back and forth, or is there an utility in Oracle which would recognise the NLS_LANG in client and change the Text data ( or a 3rd party tool)?
Any help/ideas/link is greatly appreciated. Most of the input data are text areas and it is going to be difficult to establish a data map.
Thanks,
Shiva.
-
I don't think you need to do explicitely anything other than setting your NLS_LANG parm at the fron end or client side. See the following documenatation link...
http://otn.oracle.com/docs/products/.../ch2.htm#91431
-
I did a
SQL> alter session set nls_language = SPANISH;
in the client, but still only the dates change in the output, not the data in my tables. Here are my session parameters :
SQL > select * from nls_session_parameters;
PARAMETER VALUE
------------------------------------------------------
NLS_LANGUAGE SPANISH
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SPANISH
NLS_SORT SPANISH
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
I do not have the ORAE.MSB file, but I do not think that has anything to do with the table data conversion !!
Also, since session parameters take precendence over the environment parameters, I think setting up NLS_LANGUAGE without NLS_LANG should do the trick. Correct me if I am wrong !!
Thanks,
Shiva.
[Edited by Shiva on 06-12-2002 at 03:50 PM]
-
Did you set it in the following format. I think you did not as its showing
NLS_LANGUAGE SPANISH and the rest america
Try testing it as Oracle says.. in NLS Guide. It should work.
NLS_LANG = language_territory.charset
------------------------
Here you go. I did
NLS_LANG = SPANISH.UTF8 at windows command prompt just before login to SQL*PLUS session.
PARAMETER VALUE
------------------------------------ ------------------------------------
NLS_LANGUAGE SPANISH
NLS_TERRITORY SPAIN
NLS_CURRENCY Pts
NLS_ISO_CURRENCY SPAIN
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE SPANISH
NLS_SORT SPANISH
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZH:TZM
NLS_DUAL_CURRENCY Γé¼
NLS_COMP BINARY
15 rows selected.
-
Thanks Sam for your input. I did the same and there are my session parameters :
PARAMETER VALUE
-------------------------------------------
NLS_LANGUAGE SPANISH
NLS_TERRITORY SPAIN
NLS_CURRENCY PTS
NLS_ISO_CURRENCY SPAIN
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE SPANISH
NLS_SORT SPANISH
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZH:TZM
NLS_DUAL_CURRENCY Γé¼
NLS_COMP BINARY
Now when I do a select from a table, here is what I get :
NAME
--------------------------------------------------------
ACA HOSTING CORP.
ACCESS INTERNET SERVICES
ACCESS NET PHILS. INC.
ACCESS:SEVEN COMMUNICATIONS GMBH
ADERO, INC.
ADETEL S.A. DE C.V.
ADLINK INTERNET MEDIA SPAIN
ADVANCED COMMUNICATIONS/ AYAYAI.COM
ADVANCED INTERNET CENTER (AIC)
AEC COLOMBIA LTD
AEROCOM COMMUNICATIONS SYSTEM INTERNATIONAL
AFCONX LIMITED
AFRICA ONLINE INC.
AFTAC ASN
AGARIK
AGENCE 154
AIC ASIA INTERNATIONAL SERVICES CORP.
AICOM DATA SERVICES INC.
I want to know if it is possible to get this output in spanish and not english ??
Shiva.
