Which characterset is best?
We have a semi-automated install procedure for Oracle 9.2.0.6 on windows 200 Advanced Server. However, the database is getting created with the WE8ISO8859P1 character set and the software is getting installed with the WE8MSWIN1252 character set. This causes the warnings below in export files. All of our databases are english and only need a single byte characters. Would it be better to use the WE8ISO8859P1 character set or the WE8MSWIN1252 character set?
Thanks.
Code:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table AQ$_INTERNET_AGENTS 0 rows exported
. . exporting table AQ$_INTERNET_AGENT_PRIVS 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_AQCALL 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_AQERROR 0 rows exported
. . exporting table DEF$_CALLDEST 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_DEFAULTDEST 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_DESTINATION 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_ERROR 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_LOB 0 rows exported
...etc...