Not to be snide... but the only way your string (varchar, char,
nchar) data will appear in another language is if you translate it.
Changing the character set to UTF-8 (or WE8ISO8859P1, aka Latin-1) only
allows you to *store* data in another language or set of languages. Oracle
will faithfully store whatever you give it and return it to you
Changing your NLS_LANG environment variable will, as you noticed, cause
Oracle itself to use messages in an alternate language. This is probably
not what you're really interested in. Furthermore, changing your NLS_LANG
or session language can affect your collation sequence (sort order) and
the way that non-string data (dates, numbers) are formatted for display.
But it will never, ever change the values stored in your character data
fields. This would be a bad thing for a database to do.
Addison P. Phillips Principal Consultant
Inter-Locale LLC http://www.inter-locale.com
Globalization Engineering & Consulting Services
+1 408.210.3569 (mobile) +1 408.904.4762 (fax)
On Tue, 18 Jul 2000, Magda Danish (Unicode) wrote:
> -----Original Message-----
> From: Ravi Kumar Ghanta [mailto:firstname.lastname@example.org]
> Sent: Monday, July 17, 2000 1:37 PM
> To: 'email@example.com'
> Subject: Data translation capability.
> Hello, This is my 2nd mail, Iam working on a Oracle DB, this db should be
> supported in two diff.(spanish and french) languages. I installed Oracle
> those two languages and kept the db character set as UTF8 and NCHAR
> set as WE8ISO8859P1.
> Now, I altered the session as Spanish, and I selected a table, the
> data in a table appears in English only, the comment line in bottom
> like "14 rows selected" is it alone in spanish.
> What could I do, if I want to see all table information in a language
> than english eventhough it is entered in english.
> Please advice me at the earliest.
This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:05 EDT