OraFAQ Forum: Client Tools » Query stored Unicode URDU Data through SQL*PLUS

Home » Other » Client Tools » Query stored Unicode URDU Data through SQL*PLUS (Oracle Databse,10.2.0.1.0, Window XP SP3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query stored Unicode URDU Data through SQL*PLUS [message #540139]

Fri, 20 January 2012 07:00

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

Report message to a moderator

Re: Query stored Unicode URDU Data through SQL*PLUS [message #540144 is a reply to message #540139]

Fri, 20 January 2012 07:22

Flyby
Messages: 188
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.

Report message to a moderator

Re: Query stored Unicode URDU Data through SQL*PLUS [message #540151 is a reply to message #540139]

Fri, 20 January 2012 07:47

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL*Plus does not support unicode.

Regards
Michel

Report message to a moderator

Re: Query stored Unicode URDU Data through SQL*PLUS [message #540186 is a reply to message #540151]

Fri, 20 January 2012 10:24

Flyby
Messages: 188
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

Shaheer
Messages: 50
Registered: June 2008
Location: Pakistan

Member

Thanks to all Specially Flyby

Report message to a moderator

sms form oracle forms and database [message #565015 is a reply to message #540139]

Thu, 30 August 2012 00:37

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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you post here and now what you did?
Or are you just spamming us?

Regards
Michel

Report message to a moderator

Re: sms form oracle forms and database [message #565021 is a reply to message #565019]

Thu, 30 August 2012 01:20

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I checked your other messages, you are indeed spamming us.
You are banned.

Regards
Michel

Report message to a moderator

Previous Topic:	excel & oracle database
Next Topic:	Splitting a column into multiple columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 00:26:00 CST 2025