Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!apple!well!anderson From: anderson@well.sf.ca.us (David E. Anderson) Newsgroups: comp.databases Subject: Re: Multilingual databases Summary: Oracle supports multiple languages Keywords: Oracle character set internationalization Message-ID: <17138@well.sf.ca.us> Date: 9 Apr 90 07:31:01 GMT References: <9317@wiley.UUCP> Reply-To: anderson@well.UUCP (David E. Anderson) Followup-To: comp.databases Organization: Whole Earth 'Lectronic Link, Sausalito, CA Lines: 29 In article craig@unify.UUCP (Craig Isaacs) writes: >In article <9317@wiley.UUCP> rudoff@mdi.com writes: >>I'm working on a product that will be used in many countries with >>different languages. There are important things to take in account >>when dealing with languages other than English. >> >>What character set to use...... >> >>The collation sequence of the characters...... >> >-- [Unify info deleted...] >---------------------------------------------------------------------------- >Craig Isaacs internet: craig@unify.UUCP >Unify Corporation ...!{csusac,pyramid}!unify!craig Oracle V6 provides National Language Support, which effects error messages, the character set sorting sequence and some aspects of dates, which vary from country to country. Appendix F of the Oracle V6 Database Administrator's Guide describes NLS. I think this is what you are looking for. For example, start up an instance with LANGUAGE=FRENCH and NLS_SORT=TRUE, then see messages such as ORA-00942: table ou vue n'existe pas... David E. Anderson independent database consultant formerly with Oracle US kernel support group