NLS Data conversion between Server & Client
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: NLS Data conversion between Server & Client

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Posts
    50
    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.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
    Reddy,Sam

  3. #3
    Join Date
    Apr 2002
    Posts
    50
    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]

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.
    Reddy,Sam

  5. #5
    Join Date
    Apr 2002
    Posts
    50
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width