Set the Urdu Supported Character Set in Oracle Database

Last week my Team Lead gave me the task to Store Urdu in Oracle Database (for sending SMS). For this purpose I have created a database through Database Configuration Assistant (dbca) and on Initialization Parameters step picked the Use Unicode (AL32UTF8). Setting character set to Unicode (AL32UTF8) enables you to store multiple language groups. Set the National Character Set AL16UFT16-Unicode UTF-16 Universal Character Set as shown below.



After database creation set the NLS_LANG parameter of Oracle Database on Window’s Registry as shown below.



Data value should be AMERICAN_AMERICAN.AL32UTF8. After this restart the Services of Oracle Database and TNS Listener.



To verify the NLS Database Parameters execute the following query.
select * from nls_database_parameters where parameter = any('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');



To store the Urdu character sets I set the column datatype NVARCHAR and completed the first face of my project task successfully.
Unicode supported datatypes in Oracle Databse.
1) NCHAR
2) NVARCHAR
3) NCLOB

Comments

  1. Sateesh NFebruary 24, 2013 at 4:36 AM

    Hello, as you mentioned i tried out this
    but it is not supporting to insert into database,
    Please help me in this regard,

    ReplyDelete
  2. YasirOctober 22, 2017 at 10:59 PM

    This comment has been removed by the author.

    ReplyDelete
  3. YasirOctober 22, 2017 at 11:00 PM

    Can you tell me how to generate PDF in urdu?
    and what version of PDF?
    I am using 10g and PDF Reader 11

    ReplyDelete
  4. AbidApril 4, 2020 at 8:06 AM

    find your solution yasir

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more