OraFAQ Forum: SQL & PL/SQL » NLS SETTINGS PROBLEM

Home » SQL & PL/SQL » SQL & PL/SQL » NLS SETTINGS PROBLEM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

NLS SETTINGS PROBLEM [message #217021]

Wed, 31 January 2007 06:17

prasanna_anbu
Messages: 34
Registered: November 2006
Location: india

Member

Hi we have the the flat files from countries Hungary and Czech republic while using this in the orcle we faced some problems
like junk charcters anyone help me how to convert this files to UTF-8 file format.

Report message to a moderator

Re: NLS SETTINGS PROBLEM [message #217104 is a reply to message #217021]

Wed, 31 January 2007 12:33

andrew again
Messages: 2577
Registered: March 2000

Senior Member

you need to be specific about your environment.
What OS is your database on - and what codepage/characterset is the default?
What version?
Are you using sqlldr, utl_file or something else?
What is your database characterset?
What are your current NLS? Something like this?

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Do a dump on the character data from the table to examine the byte contents - your app which is displaying the data could be the problem rather than a problem with getting the data into the table.

-- here you can see that characters aren't displaying 
correctly, but have the correct byte values
-- http://www.tachyonsoft.com/uc0020.htm#U20AC

SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';
NLS_CHARACTERSET	AL32UTF8

create table utf8_tst(col1 varchar2(1 char));

-- Euro is U+20AC
insert into utf8_tst values (unistr('\20AC'));
-- Small Greek Gamma U+03B3
insert into utf8_tst values (unistr('\03B3'));
insert into utf8_tst values (unistr('A'));

select col1, vsize(col1), dump(col1, 1010) Decimal_bytes, dump(col1, 1016) Hex_Bytes from utf8_tst;
� 	3	Typ=1 Len=3 CharacterSet=AL32UTF8: 226,130,172	Typ=1 Len=3 CharacterSet=AL32UTF8: e2,82,ac
�	2	Typ=1 Len=2 CharacterSet=AL32UTF8: 206,179	Typ=1 Len=2 CharacterSet=AL32UTF8: ce,b3
A	1	Typ=1 Len=1 CharacterSet=AL32UTF8: 65	Typ=1 Len=1 CharacterSet=AL32UTF8: 41

SQLPLUS can't display UTF8 characters - try isqlplus, because it runs in a browser and browsers can display many utf8 characters without issue

[Updated on: Wed, 31 January 2007 12:51]

Report message to a moderator

Previous Topic:	SQL beeded
Next Topic:	Database Time in Oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 05:41:03 CST 2024