Home » SQL & PL/SQL » Client Tools » Query stored Unicode URDU Data through SQL*PLUS (Oracle Databse,10.2.0.1.0, Window XP SP3)
Query stored Unicode URDU Data through SQL*PLUS [message #540139] Fri, 20 January 2012 07:00 Go to next message
Shaheer
Messages: 50
Registered: June 2008
Location: Pakistan
Member
I have install Oracle Databse 10g and set the NLS parameters as follows:-

NLS_CHARACTERSET = AL32UTF8
NLS_NCHAR_CHARACTERSET = AL16UTF16

I have stored Unicode Urdu data in table (Column type is NVARCHAR2) using iSQLPLUS. Unicode urdu data stored properly and Retrieving in correct formate in iSQLPLUS through browser.

The problem is when i Query the unicode urdu data through SQL*PLUS and TOAD, it shows ??????? not in proper formate in SQL*PLUS and TOAD.

I want that SQL*PLUS and TOAD show unicode urdu data in proper formate.

Kindly help me.

Regards
Shaheer Badar
Re: Query stored Unicode URDU Data through SQL*PLUS [message #540144 is a reply to message #540139] Fri, 20 January 2012 07:22 Go to previous messageGo to next message
Flyby
Messages: 143
Registered: March 2011
Location: Belgium
Senior Member
check the nls settings of the sql/toad session of the client which starts the session. If not correctly set, the client may translate it wrong to the database.
Re: Query stored Unicode URDU Data through SQL*PLUS [message #540151 is a reply to message #540139] Fri, 20 January 2012 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 58577
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Plus does not support unicode.

Regards
Michel
Re: Query stored Unicode URDU Data through SQL*PLUS [message #540186 is a reply to message #540151] Fri, 20 January 2012 10:24 Go to previous messageGo to next message
Flyby
Messages: 143
Registered: March 2011
Location: Belgium
Senior Member
Interesting link on Oracle unicode
SQL Snippets: Unicode - Unicode and SQL*Plus (Windows)

[Updated on: Fri, 20 January 2012 10:31]

Report message to a moderator

Re: Query stored Unicode URDU Data through SQL*PLUS [message #540341 is a reply to message #540186] Sun, 22 January 2012 08:23 Go to previous messageGo to next message
Shaheer
Messages: 50
Registered: June 2008
Location: Pakistan
Member
Thanks to all Specially Flyby
sms form oracle forms and database [message #565015 is a reply to message #540139] Thu, 30 August 2012 00:37 Go to previous messageGo to next message
hafizfozaib@gmail.com
Messages: 1
Registered: August 2012
Location: faisalabad
Junior Member
hi

i have sent sms to mobile uding oracle forms and databse.
successfully



[Updated on: Thu, 30 August 2012 01:21] by Moderator

Report message to a moderator

Re: sms form oracle forms and database [message #565019 is a reply to message #565015] Thu, 30 August 2012 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 58577
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you post here and now what you did?
Or are you just spamming us?

Regards
Michel
Re: sms form oracle forms and database [message #565021 is a reply to message #565019] Thu, 30 August 2012 01:20 Go to previous message
Michel Cadot
Messages: 58577
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I checked your other messages, you are indeed spamming us.
You are banned.

Regards
Michel
Previous Topic: excel & oracle database
Next Topic: Splitting a column into multiple columns
Goto Forum:
  


Current Time: Sat Jul 26 00:21:10 CDT 2014

Total time taken to generate the page: 0.05740 seconds