Home » SQL & PL/SQL » SQL & PL/SQL » number to char (Oracle9i)
number to char [message #435797] Fri, 18 December 2009 01:27 Go to next message
prakashaa
Messages: 31
Registered: November 2009
Location: Bangalore
Member
Hi Experts Good morning to all You,
I have a Column TEXT with the data type VARCHAR2(4000 Bytes)

The column TEXT contains 1000 values
the following values are some

abc4
abc5
ゥl𐃱6
abc7
𐃹ﺄ︵9

How can we display those values like abc4
abc5
abc6

These values are not eual to the alphanumeric value a b c 4,
a b c 5,
a b c 6
If we copy and paste those values in notepad it's printing some other values with symobls.
Please help me in this scenario.
Thanks in advance
Re: number to char [message #435804 is a reply to message #435797] Fri, 18 December 2009 01:52 Go to previous messageGo to next message
prakashaa
Messages: 31
Registered: November 2009
Location: Bangalore
Member
Iam giving one more clarification for that the data is entered in Japanese language in the Form from end users like abc4
But it's storing in the database like this abc2

So my aim is while retriveing data from the databse using SELECT statement it should display like abc4


Re: number to char [message #435806 is a reply to message #435797] Fri, 18 December 2009 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
where col like 'a b c _'
and substr(col,-1,1) in (1,2,3,4,5,6,7,8,9,0)

Regards
Michel
Re: number to char [message #435925 is a reply to message #435797] Sat, 19 December 2009 01:36 Go to previous messageGo to next message
prakashaa
Messages: 31
Registered: November 2009
Location: Bangalore
Member
My question is if some one entered data in the form in Japanese language like abc4
But it's storing in the database like
a𐌪𐜑4
So my aim is while retriveing data from the databse using SELECT statement it should display like abc4

i.e What the data is entered in the form.
Re: number to char [message #435933 is a reply to message #435925] Sat, 19 December 2009 03:31 Go to previous message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use correct NLS_LANG (NLS_CHARACTERSET part) from the client to the server.

Regards
Michel
Previous Topic: Create Bitmap index on primary key
Next Topic: Date format discrepancies
Goto Forum:
  


Current Time: Wed Sep 28 22:48:39 CDT 2016

Total time taken to generate the page: 0.16780 seconds