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: Tim Johnston <oraclestuff_at_gmail.com>
Date: Tue, 26 Oct 2004 12:10:05 -0400
Message-ID: <69a371a704102609108a03edb@mail.gmail.com>


As Allan has said... Do you homework before the switch... Both UTF8 and WE8ISO8859P1 are strict supersets of US7ASCII... You can directly convert you database from US7ASCII to either of these charactersets...  However, if you convert to WE8ISO8859P1 and then later decide you should have gone to UTF8 (or vice versa) then you have a migration on your hands...

On the other hand, moving to UTF8 does have potential issues... Variable length characters... Application support etc...

Good luck

Tim

On Tue, 26 Oct 2004 10:32:35 -0400, Gene Sais <gsais_at_co.palm-beach.fl.us> wrote:
> I am upgrading my databases from 8i to 9.2.0.5. Currently, most of my
> databases are using the character set US7ASCII. What character set do
> most people in the USA use (WE8ISO8859P1)?
>
> Thanks,
> Gene
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 26 2004 - 11:06:41 CDT

Original text of this message

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