From jprem@kssnet.co.jp Tue, 08 Jul 2003 03:21:12 -0700 From: Prem Khanna J Date: Tue, 08 Jul 2003 03:21:12 -0700 Subject: Re: RE: character set conversion ?! Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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).