Home » RDBMS Server » Server Utilities » SPECIAL CHARACTERS
SPECIAL CHARACTERS [message #198323] Mon, 16 October 2006 10:38 Go to next message
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

Re: SPECIAL CHARACTERS [message #198546 is a reply to message #198323] Tue, 17 October 2006 10:02 Go to previous message
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
Senior Member

i have the solution.. thanks for more information look for "spool result" posted by me...
Previous Topic: loading date
Next Topic: Insert diacritic marks
Goto Forum:
  


Current Time: Sun Dec 04 06:11:37 CST 2016

Total time taken to generate the page: 0.07694 seconds