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: setting character set for imp

Re: setting character set for imp

From: Phil Singer <psinger1_at_chartermi.net>
Date: Tue, 19 Jul 2005 20:33:09 -0700
Message-ID: <42DDC5F5.3060406@chartermi.net>


Janine Sisk wrote:

>
> I don't understand why we're having this problem in the first place;
> this conversion just adds an extra bit to each character, it's not
> supposed to change anything!
>
> janine

Oh yes it is.

Create a single varchar2(50) column test table. Insert some rows containing Euro symbols and other specialized European symbols. Export and import it. Notice how all your specialized upper ascii characters have been converted to question marks. Then search Metalink (there are a couple of good articles there which explain how National Language Support and character sets work.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 19 2005 - 19:35:56 CDT

Original text of this message

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