how to load data which is in nonenglish language

[Abhishek]

hi all
i recieved csv files which contain japanese data
now I want to enter this data in my database which is configured for nomal language(english or numbers or special characters) through sql loader

plz help me out that how can I carry out this task



thanks for all ur appreciable efforts

[PAVB]

You might want to involve your DBA on the project.

[Abhishek]

hey I m alone here dats y I need u ppl's help
Is neone is there who can help me out from this problem.

[JChiappa]

Abhishek, I work frequently with non-English data, so I must insist in the answer : see, non-ocidental languages (as Japanese) have more characters than the "space" present in an English-only database, your program can´t do NONE about this, is a PHYSICAL thing... So, the DBA ** must ** recreate/convert this database, allowing more "space" for the extra characters required, if you are the programmer only you don´t have A THING to do about it...

Regards,

Chiappa

[Abhishek]

could neone tell me the steps from very scratch

I shall be greatfull for them

thanx a lot in advance

[Bore]

1) Normal language (english) makes me a bit angry man. What's wrong with the other languages? Moreover Oracle supports most of them for ages
2) Post here
select * from nls_database_parameters where parameterlike '%CHARACTERSET%'

[Abhishek]

hey bore
I just wanna say that it not support idlographic lang. like japanese


the result for ur query is below

NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16


thanx for ur efforts