| SPECIAL CHARACTERS [message #198323] |
Mon, 16 October 2006 10:38  |
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
|
Senior Member |
|
|
Hi:
I´m loading some data with SQL loader unfotunely i hvae many special characters like
â,ê,î,ô,û
á,é,í,ó,ú
Ñ,ñ
and when i run my control file i have strange characters like ¬ and others inserted in my database
My database server has UTF8 as character set, in my control file i've tried with many character sets for example
UTF8
US7ASCII
YUG7ASCII
...win1252
etc
and much more... anyone knows a characterset that support this kind of characters...
here my session parameters
SQL> select * from nls_session_parameters;
PARAMETER VALUE
------------------------- -------------------------
NLS_LANGUAGE MEXICAN SPANISH
NLS_TERRITORY MEXICO
NLS_CURRENCY $
NLS_ISO_CURRENCY MEXICO
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE MEXICAN SPANISH
NLS_SORT WEST_EUROPEAN
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
PARAMETER VALUE
------------------------- -------------------------
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZ
R
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
and my database parameters
SQL> select * from nls_session_parameters;
PARAMETER VALUE
------------------------- -------------------------
NLS_LANGUAGE MEXICAN SPANISH
NLS_TERRITORY MEXICO
NLS_CURRENCY $
NLS_ISO_CURRENCY MEXICO
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE MEXICAN SPANISH
NLS_SORT WEST_EUROPEAN
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
PARAMETER VALUE
------------------------- -------------------------
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZ
R
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
17 rows selected.
SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------- -------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_LANGUAGE AMERICAN
NLS_CSMIG_SCHEMA_VERSION 1
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT YYYY-MM-DD
NLS_DATE_LANGUAGE AMERICAN
PARAMETER VALUE
------------------------- -------------------------
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
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_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
PARAMETER VALUE
------------------------- -------------------------
NLS_RDBMS_VERSION 9.2.0.5.0
NLS_SAVED_NCHAR_CS WE8ISO8859P1
finally my instance parameters
SQL> select * from nls_instance_parameters;
PARAMETER VALUE
------------------------- -------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_SORT
NLS_DATE_LANGUAGE
NLS_DATE_FORMAT YYYY-MM-DD
NLS_CURRENCY
NLS_NUMERIC_CHARACTERS
NLS_ISO_CURRENCY
NLS_CALENDAR
NLS_TIME_FORMAT
NLS_TIMESTAMP_FORMAT
PARAMETER VALUE
------------------------- -------------------
NLS_TIME_TZ_FORMAT
NLS_TIMESTAMP_TZ_FORMAT
NLS_DUAL_CURRENCY
NLS_COMP
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
i really need this characters in my database...
When i do it with a insert with ascii function the characters are inserted, but when i have a text file i can´t specify a function ascii...
Any ideas or suggestions
Oscar
[Updated on: Mon, 16 October 2006 10:40] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
