How to Store Non English Words In Oracle Database

Asked Mar 12 '22 at 05:42

Active Jun 09 '22 at 07:58

Viewed 43 times

Insert into Tamil_language values (1, N'மோதிரம்')
Insert into Tamil_language values (2, 'மோதிரம்')

Select * from Tamil_language

Output

i      j
----------- ----------
1      மோதிரம்
2      ???????

How to do this using store procedure in Oracle Database?
How To Add 'N' Prefix For the Store procedure Parameter?
Please Help me if any one know this.

edited Jun 09 '22 at 07:58

Arulkumar

12,966
14
47
68

asked Mar 12 '22 at 05:42

Khizer Mahammad

Which tool do you use? What is the database character set? – Wernfried Domscheit Mar 12 '22 at 05:52
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Mar 13 '22 at 02:43
I am Using Pl/SQL Developer 13 and Oracle Database 12c . – Khizer Mahammad Mar 14 '22 at 05:54
Insert into Tamil_language values (1, 'பெண்டிரேம்') Insert into Tamil_language values (1, N'பெண்டிரேம்') Select * from Tamil_language Output i j ----------- ---------- 1 ?????????? 1 பெண்டிரேம் – Khizer Mahammad Mar 14 '22 at 05:56
How to add N Prefix for Store Procedure Parameter ? – Khizer Mahammad Mar 14 '22 at 05:58

How to Store Non English Words In Oracle Database

0 Answers0