Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2002
    Location
    India
    Posts
    5

    Question Unanswered: Internationalization

    Hi,

    I would like to know how can i achieve internationalization. We have a requirement for internalization with about five international languages to be supported.

    I have no idea on how to do this, do i create seperate database with seperate values entered for all languages ... any help in this regards is appreciated.

    Thanks in advance,

    Brillian

  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    15

    Re: Internationalization

    It is not necessary to create separate database for each language, by default oracle 8.1.6(currently we are using) supports internalisation.

    Note : If you use character-numeric format(&#7894) for storing data, IE will automatically display the corresponding characters in User interface.

  3. #3
    Join Date
    Nov 2002
    Location
    India
    Posts
    5

    Exclamation

    Hi What i meant to ask was not just for characters. to put a broader scene, i want to store say the statement "This is a problem in query" this statement must appear with proper grammer and syntax in the other five languages! how do i acheive this without creating seperate tables/ database is my main concern as we do not wish to maintain seperate tables/ databases for the same.

    Hope you got the picture clear..

  4. #4
    Join Date
    Jan 2002
    Location
    India
    Posts
    15
    I don't think grammatical translation is possible in DB.

    from procedure return the error code and for the error code define the description in property file(in Java) and use resource loader(in java) to load the description of the error.


    Note:In java using different property files for different languages you can acheive multi language support

    you have to define a code for every description.

  5. #5
    Join Date
    Nov 2002
    Location
    India
    Posts
    5
    Hi Thanks for the response,

    however i am not using Java for coding! we intend to use Oracle Forms, is there any way other than defining code in program to achieve atleast a marginal level of acuracy.

    Thanks in advance

    Brillian

  6. #6
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    If the messages you wish translated are your own, and depending on the amount of data you have you could consider adding a language column to each table ('GB','DE') or whatever and creating views on the tables for reading data. Hold a package variable for the language.

    It's pseudocode so you'll have to work out the details/syntax....

    create or replace package utils is
    LangCode VARCHAR(2) := 'GB'; -- GB is default for new connections
    procedure SetLanguage( inLangCode .... )
    function GetLanguage return varchar2 ...
    pragma restrict_references( SetLanguage.... )
    pragma restrict_references( GetLanguage.... )
    end;
    /
    create or replace view MyTableLang as
    select *
    from mytable
    where languagecode = utils.GetLanguage;
    /
    create or replace trigger MyTableIns_Trg
    before insert on MyTable
    for each row
    begin
    :new.Languagecode := utils.GetLanguage;
    end;
    /

    In this example GB is always the default language but any session can call utils.SetLanguage to change it.

    Your table "MyTable" may look something like
    MCODE LANGUAGE MESSAGE
    100 'GB' An error
    100 'DE' Ein fehler
    101 'GB' Hello
    101 'DE' Hallo

    etc.

    Your old primary key of MCODE would become (MCODE,LANGUAGE)

    You'll have to consider/check performance issues for any large tables etc, although if your selects are generally returning small datasets it shouldn't be an issue.

    Hth
    Bill

  7. #7
    Join Date
    Nov 2002
    Location
    India
    Posts
    5
    Thanks BILLM

Posting Permissions

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