Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Character Set issues

Character Set issues

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Fri, 10 Jan 2003 19:45:18 GMT
Message-ID: <ipFT9.24293$Mv3.163005699@news-text.cableinet.net>


Hi,

8.1.5 Solaris 7
8.1.7 Solaris 8

I have a very annoyng character set problem that i can't figure out, mainly that £'s display as #'s. I had all characters displaying correctly in in my 8.1.5 database so i did an export. I want to import this into my 8.1.7 database.

When i do the imp i get

Warning: the objects were exported by xxx, not by you

import done in US7ASCII character set and WE8ISO8859P1 NCHAR character set import server uses WE8ISO8859P1 character set (possible charset conversion)

however when i check both db's character sets i get..

PL/SQL Release 8.1.5.0.0 - Production

SQL> select * from nls_database_parameters;

PARAMETER                      VALUE

------------------------------ ------------------------------
NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P1 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-YY NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM PARAMETER VALUE
------------------------------ ------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-YY HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM TZH:T NLS_DUAL_CURRENCY $ NLS_COMP NLS_NCHAR_CHARACTERSET WE8ISO8859P1 NLS_RDBMS_VERSION 8.1.5.0.0

and

JServer Release 8.1.7.0.1 - Production

SQL> select * from nls_database_parameters;

PARAMETER                      VALUE

------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P1 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_NCHAR_CHARACTERSET WE8ISO8859P1 NLS_RDBMS_VERSION 8.1.7.0.1

can anyone please spot where i'm going wrong?

thanks

Tom Received on Fri Jan 10 2003 - 13:45:18 CST

Original text of this message

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