Re: Internationalization - poinetrs please

Give him a break!

1. Internationalisation (which Oracle mis-spells -:) ) is not the best documented topic. Many manuals treat it as a side-issue and stop just where you want to start.
2. Manuals for any computer subject are of limited use for "how do I?" type questions, and this is a case in point.

Remember 2 golden rules

1. NEVER put any hard-coded message texts in any computer source code (be it Oracle PL/SQL or anything else), ALWAYS use message-codes, message-ID's or some such method with some method that converts the code into a text message in the users language.
2. Do not build your database as 7-bit ASCII (which Oracle unfortunately defaults to), use as a minimum one of the ISO8859 charactersets, usually ISO8859-1 (which Oracle calls WE8ISO8859P1).

Try the following SQL, it should give you some clues: SELECT * FROM NLS_DATABASE_PARAMETERS; ALTER SESSION SET NLS_LANGUAGE='ENGLISH'; SELECT TO_CHAR(SYSDATE,'Day DD Month YYYY') FROM DUAL; ALTER SESSION SET NLS_LANGUAGE='FRENCH'; SELECT TO_CHAR(SYSDATE,'Day DD Month YYYY') FROM DUAL; ALTER SESSION SET NLS_LANGUAGE='GERMAN'; SELECT TO_CHAR(SYSDATE,'Day DD Month YYYY') FROM DUAL;

And please pose a specific question. Received on Mon Nov 28 2005 - 10:01:08 CST