I too am planning to convert from US7ASCII to WE8ISO8859P1. I am moving the databases from HP boxes to Sun Solaris Systems. I am using Exp/Imp to migrate. Old DB has US7ASCII character set. New DB will be created in WE8ISO8859P1. I would like to know if the above character set conversion is required? Any help is appreciated. -- Babu -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jesse, Rich Sent: Tuesday, October 26, 2004 11:55 AM To: gsais@xxxxxxxxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: Which Character Set for 9.2 I completely forgot about the "csscan" utility -- it should give you an = idea of how much work you're in for. Of course, it's probably best to run this on a recent complete copy of = your DB, if possible... Rich -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx Sent: Tuesday, October 26, 2004 12:55 PM Subject: RE: Which Character Set for 9.2 Yeah, amen, etc. We took finaancials at 11.5.7 to utf-8 and we had a lot of data, principally from Russia, that had already been put into non-utf-8 compliant homebrew software. Boy was it fun to migrate that stuff! Allan -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l