how to load data which is in nonenglish language
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to load data which is in nonenglish language

  1. #1
    Join Date
    Dec 2007
    Posts
    12

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Dec 2007
    Posts
    12
    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.

  4. #4
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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

  5. #5
    Join Date
    Dec 2007
    Posts
    12
    could neone tell me the steps from very scratch

    I shall be greatfull for them

    thanx a lot in advance

  6. #6
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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%'

  7. #7
    Join Date
    Dec 2007
    Posts
    12
    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
  •  



Click Here to Expand Forum to Full Width