Re: Character Sets

From: <shashism_at_my-dejanews.com>
Date: Tue, 30 Jun 1998 07:16:12 GMT
Message-ID: <6na3bs$shu$1@nnrp1.dejanews.com>

Hi,

The character-set is set when creating a database. You can change the character-set of a session and not the instance by changing in the oracle.ini / registry
( e.g NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 ).

You can export the database of any character-set and import to any database of different character-set.

Shashidhar S M

In article <01bda3a1$992f06a0$1fc612cf_at_298.6.1.1.uu.net>, "RD" <RD_at_uu.net> wrote:
>
> I've created an Oracle Database that needs to run from another Oracle
> server that is set up with a different character set. This is causing me
> to loose some characters like copyright characters. Does anyone know a way
> around this such as exporting the data into the new character set or a
> trasnaltion tool, or even a place where I can get a chart of the different
> characters and their byte values for the given character set?
>
> Thanks in advance.
>
> Rob
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jun 30 1998 - 02:16:12 CDT