Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: character set conversion ?!

Re: RE: character set conversion ?!

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 08 Jul 2003 03:21:12 -0700
Message-ID: <F001.005C3D75.20030708031437@fatcity.com>


thanx a lot for your info' Regis.


i need to calculate the exact time taken for IMP.
the source and target char. set is JA16SJIS,whereas i have UTF8 on test Database.

So thought of changing it to JA16SJIS.

ok....if there is no other option ...let me re-create the DB.

perhaps,it's a test DB.

no envy on UTF...Regis ;)

Jp.

08-07-2003 18:42:51, Regis Biassala <[EMAIL PROTECTED]> wrote:

>1) NO (yes if you re-create the database)
>2) UTF8 is a superset of JS16SJIS ...
>You could leave your database as it is now (NLS_CHARACTERSET = UTF8) and
>play with the NLS_LANG to get correct data stored
>in the database(i.e: data related to JS16SJIS).
>NOTE: setting NLS_LANG at client side or database server side forces
>character conversion. It controls the behaving of
>NLS_NCHAR_CHARACTERSET.
>Ok what's your problem beside having the envy to change the character set ?
>
>Regis



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Jul 08 2003 - 05:21:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US