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

Home -> Community -> Usenet -> c.d.o.server -> Re: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

Re: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

From: codadilupo <codadilupo_at_operamail.com>
Date: Wed, 25 Jul 2007 17:23:48 +0200
Message-ID: <46a76b03$0$21207$5fc30a8@news.tiscali.it> 





Laurenz Albe wrote:



> The right thing would be to do an ALTER DATABASE CHARACTER SET to

> change the database to the encoding of the data that are stored in it.




Yes, but going straight this way "gk24" would lose all its special
characters. How can he keep the "wrong" characters? The only solution
that I see is to dump out the data in a textfile (using sqlplus or
another tool) and reinserting them after the charset change.


-- 
CdL


Received on Wed Jul 25 2007 - 10:23:48 CDT












Original text of this message













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