Tuesday, January 7, 2014

Using Bangla(Unicode) In Oracle Database.

SQL> conn /as sysdba
Connected.
SQL>
SQL>
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP RESTRICT;
ORACLE instance started.

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             402654632 bytes
Database Buffers          369098752 bytes
Redo Buffers                5259264 bytes
Database mounted.
Database opened.

SQL> ALTER DATABASE CHARACTER SET AL32UTF8;

Database altered.

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP;
ORACLE instance started.

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             402654632 bytes
Database Buffers          369098752 bytes
Redo Buffers                5259264 bytes
Database mounted.
Database opened.

Now Check Using Bangla Using Toad 10.5 and  Avro Bangla keyboard.


43 comments:

  1. You certainly deserve a round of applause for your post and more specifically, your blog in general. Very high quality material.
    oracle dba training in chennai

    ReplyDelete
  2. Thanks for Information Oracle Online Training Oracle is an object-relational database management system created and marketed by Oracle Corporation.Oracle Online Training

    ReplyDelete
  3. Dear Mr. Rajib Pradhan

    I used to read your nice topic on Using Bangla(Unicode) In Oracle Database

    through your blog

    http://rajiboracle.blogspot.com/2014/01/using-banglaunicode-in-oracle-database.html


    Can you please let me know there is any step wise procedure to print bangla unicode font
    on 10g reports as well as on pdf output.


    Thanks

    Md. Shamsuddin Khaled

    opera_bd@yahoo.com

    ReplyDelete
  4. How to use Bangla Unicode in oracle forms and reports 11g?

    ReplyDelete
  5. oracle database 11g Forms.To input bangla font by the forms what should i do.if
    you kindly inform me so i will be so happy.

    ReplyDelete
  6. Dear ,

    I am currently working for an application inOracle Forms & Reports 11g R1.
    Database oracle 11g G1
    Operating system RHEL 6.5

    Specs require input to be in Bengali Unicode.
    Problem is :
    WHEN I RUN THE APPLICATION, IT SHOWS SQUARE BOXES ONLY AND THE TEXT ITEMS (WHEN I INPUT IN BENGALI) SHOWS ???????????

    Please, anybody, can u help ??

    Thanks
    Ashis(ashis.su@gmail.com)

    ReplyDelete
    Replies
    1. I m also facing the same error..
      How can fix, Need help..

      Delete
    2. I have download latest Toad vr 12.12.0.40 and able to save.
      Thanks.

      Delete
  7. If show error ORA-12712: new character set must be a superset of old character set
    Then Try SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

    ReplyDelete
  8. I am facing a problem for Oracle Developer 10g.
    I am trying to inserting ০, ১, ২, ... as numeric.
    But Oracle does not recognized ০, ১, ২, ... as numeric,
    it only recognized as character.

    ReplyDelete
  9. This comment has been removed by the author.

    ReplyDelete
  10. I enjoy what you guys are usually up too. This sort of clever work and coverage! Keep up the wonderful works guys I’ve added you guys to my blog roll.

    python training in chennai

    python training in bangalore

    python online training

    python training in pune

    ReplyDelete
  11. I’d love to be a part of group where I can get advice from other experienced people that share the same interest. If you have any recommendations, please let me know. Thank you.

    java training in chennai

    java training in bangalore

    java online training

    java training in pune

    ReplyDelete
  12. ERROR found IN ORACLE 11 g r2 ORA-12712: new character set must be a superset of old character set

    ReplyDelete
  13. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    Python training in usa
    Python training in marathahalli
    Python training in pune

    ReplyDelete

  14. Greetings. I know this is somewhat off-topic, but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform like yours, and I’m having difficulty finding one? Thanks a lot.

    AWS Training in Bangalore | Amazon Web Services Training in Bangalore

    Amazon Web Services Training in Pune | Best AWS Training in Pune

    AWS Online Training | Online AWS Certification Course - Gangboard

    ReplyDelete

  15. Thanks for sharing such a useful post and i hope it’s useful to many people for developing their skill .Thanks a lot.
    aws online training
    aws training in hyderabad
    aws online training in hyderabad

    ReplyDelete
  16. Post is very useful. Thank you, this useful information.

    Learn Best Microsoft Training in Bangalore from Experts. Softgen Infotech offers the Best Microsoft Training Course.100% Placement Assistance, Live Classroom Sessions, Only Technical Profiles, 24x7 Lab Infrastructure Support.

    ReplyDelete
  17. An outstanding share! I have just forwarded this onto a colleague who had been doing a little research on this. And he actually bought me dinner because I found it for him... lol. So let me reword this.... Thank YOU for the meal!! But yeah, thanks for spending time to talk about this matter here on your blog.

    ReplyDelete
  18. wow, great blog! I learned a lot and Really nice content. Thank you for sharing this unique information about this topic.. oracle training in chennai

    ReplyDelete
  19. Great post! I am actually getting ready to across this information, It’s very helpful for this blog. Also great with all of the valuable information you have Keep up the good work you are doing well.
    CRS Info Solutions Salesforce training for beginners   

    ReplyDelete
  20. Having read this I believed it was extremely informative. I appreciate you finding the time and energy to put this content together. I once again find myself personally spending a significant amount of time both reading and leaving comments. But so what, it was still worth it!
    Technology

    ReplyDelete
  21. Wow what a great blog, i really enjoyed reading this, good luck in your work. Otherwise anyone wants to learn 3D Max so contact here- +91-9311002620 or visit website- https://www.htsindia.com/Courses/cad-cam-cae/autocad-3ds-max-training-course

    ReplyDelete
  22. Infycle Technologies, the best software training institute in Chennai offers the No.1 Big Data Training in Chennai for tech professionals. Apart from the Big Data training, other courses such as Oracle, Java, Hadoop, Selenium, Android, and iOS Development, Data Science will also be trained with 100% hands-on training. After the completion of training, the students will be sent for placement interviews in the core MNC's. Dial 7502633633 to get more info and a free demo.No.1 Big Data Training Chennai | Infycle Technologies

    ReplyDelete


  23. Grab the Oracle Training in Chennai from Infycle Technologies the best software training and placement center in Chennai which is providing technical software courses such as Data Science, Artificial Intelligence, Cyber Security, Big Data, Java, Hadoop, Selenium, Android, and iOS Development, DevOps, . etc with 100% hands-on practical training. Call 7504633633 to get a free demo with more info.

    ReplyDelete