-
how to load data which is in nonenglish language
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
-
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...
Regards,
Chiappa
-
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%'
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|