DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to load data which is in nonenglish language

  1. 12-17-2007, 04:35 AM #1
    Abhishek
    Abhishek is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 12-17-2007, 04:16 PM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.
    Reply With Quote Reply With Quote
  3. 12-18-2007, 05:05 AM #3
    Abhishek
    Abhishek is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  4. 12-18-2007, 05:56 AM #4
    JChiappa
    JChiappa is offline Senior Member
    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
    Reply With Quote Reply With Quote
  5. 12-19-2007, 08:09 AM #5
    Abhishek
    Abhishek is offline Junior Member
    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
    Reply With Quote Reply With Quote
  6. 12-21-2007, 05:27 AM #6
    Bore
    Bore is offline Advisor
    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%'
    Reply With Quote Reply With Quote
  7. 12-21-2007, 07:12 AM #7
    Abhishek
    Abhishek is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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