how to load data which is in nonenglish language
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
You might want to involve your DBA on the project.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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.
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...
could neone tell me the steps from very scratch
I shall be greatfull for them
thanx a lot in advance
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%'
I just wanna say that it not support idlographic lang. like japanese
the result for ur query is below
thanx for ur efforts
Click Here to Expand Forum to Full Width