Re: FW: Data translation capability.

Date: Wed Jul 19 2000 - 07:05:53 EDT

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
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 []
> Sent: Monday, July 17, 2000 1:37 PM
> To: ''
> 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
> in
> 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
> other
> than english eventhough it is entered in english.
> Please advice me at the earliest.
> Regards

This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:05 EDT