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: Which Character Set for 9.2

RE: Which Character Set for 9.2

From: Janardhana Babu Donga <jbdonga_at_ucdavis.edu>
Date: Fri, 29 Oct 2004 09:06:23 -0700
Message-ID: <B23D6580B3155F45B6BF18DCBE4D9A2D6325D4@matmail.ucdavis.edu>


Dear List,  

I am of the opinion that Oracle uses 8bits to store the data, but just most significant bit is not used, and so the data in US7ASCII character set is OK and not corrupted. Am I correct ?  

If it is really going to be a lot of corruption because of 7-bits, I may better convert the database character set from US7ASCII to WE8ISO8859P1 asap. Any Comments?  


From: M.Godlewski [mailto:mcgodlewski_at_yahoo.com] Sent: Friday, October 29, 2004 6:35 AM
To: jbdonga_at_ucdavis.edu
Subject: RE: Which Character Set for 9.2  

Janardhana,  

I think people are changing character sets to avoid the possibility of corruption.  

If the client your using has a different character set i.e. WE8ISO8859P1 and your database has a character set of US7ASCII, then when you store data in the database it requires 8 bits to store it, and there are only 7 bits available in the database. You will find your data has the potential for corruption. You will see question marks returned when you go to pull the data out of the database.  

If your database has 8 bits available to store the 8 bits of client data, then when you retrieve the data you will see the data without question marks.  

There are some articles on metalink about sub sets and super sets of the character set. You may want to have a look.

Janardhana Babu Donga <jbdonga_at_ucdavis.edu> wrote:

Why is the 8 bits good and 7 bits bad?
Is there any valid reason?

-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Wednesday, October 27, 2004 1:58 PM To: jbdonga_at_ucdavis.edu
Cc: Nelson, Allan; rich.jesse_at_quadtechworld.com; gsais_at_co.palm-beach.fl.us; oracle-l_at_freelists.org
Subject: Re: Which Character Set for 9.2

On Wed, 27 Oct 2004 10:05:34 -0700, Janardhana Babu Donga wrote:
> Dear List,
>
> If it is not required to convert from US7ASCII to WE8ISO8859P1, I don't
> understand why so many people are changing their character set to
> WE8ISO8859P1 from US7ASCII. Could some one explain please?

7bits bad, 8 bits good.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

  _____  

Do you Yahoo!?
Yahoo!
<http://us.rd.yahoo.com/mail_us/taglines/aac/*http:/promotions.yahoo.com/new
_mail/static/ease.html>  Mail Address AutoComplete - You start. We finish.



--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 29 2004 - 11:02:11 CDT

Original text of this message

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