Hey Gene, We use WE8ISO8859P1 (and since it's a superset of US7ASCII, the change = is trivial), but you may want to look at WE8ISO8859P15 if you do any = business with Europe, since P15 contains the Euro symbol. Not that = you'll typically store it, but perhaps in comment columns and the like. There are enough potential changes in moving to UTF8/16 to scare me away = from it, and we didn't need to support any of the potential advantages = of those anyway. GL! Rich Rich Jesse System/Database Administrator rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA -----Original Message----- Sent: Tuesday, October 26, 2004 9:36 AM Subject: Re: Which Character Set for 9.2 Clarification: What character set do most people in the USA use (WE8ISO8859P1) for their 9.2 databases? =20 >>> Gene Sais 10/26/2004 10:32:35 AM >>> 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)? =20 =20 Thanks, Gene -- //www.freelists.org/webpage/oracle-l