Home » SQL & PL/SQL » SQL & PL/SQL » Inserting mathematical symbol ≤ in Oracle table (Oracle 11g)
icon5.gif  Inserting mathematical symbol ≤ in Oracle table [message #638068] Tue, 02 June 2015 02:12 Go to next message
Roshnie
Messages: 1
Registered: June 2015
Junior Member
Hello,

I am unable to insert mathematical symbol ≤ (less or equal to) and ≥ (greater or equal to) in oracle table.
Try the syntax below but it didn't work...

SET DEFINE OFF;
update TABLENAME
set COLNAME = 'Test ≤ Test'
where COLNAME2 = 'XX';

Can someone please help me ?

Thanks in advance
Roshnie
Re: Inserting mathematical symbol ≤ in Oracle table [message #638072 is a reply to message #638068] Tue, 02 June 2015 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

"am unable" is not an Oracle error and help us in no way to see what is your problem.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Use SQL*Plus and copy and paste your session, the WHOLE session.
Specify what is client program.

Note: I am able to insert them.

Re: Inserting mathematical symbol ≤ in Oracle table [message #638073 is a reply to message #638068] Tue, 02 June 2015 02:23 Go to previous messageGo to next message
jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum
Senior Member

You cant perform this action, use '<=' instead of '≤'
Re: Inserting mathematical symbol ≤ in Oracle table [message #638080 is a reply to message #638073] Tue, 02 June 2015 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can insert those characters if:
* your client OS knows these characters
* your client program supports these characters
* your CLIENT NLS_LANG is set to a character set containing these characters
* your database character set contains these characters

Re: Inserting mathematical symbol ≤ in Oracle table [message #638085 is a reply to message #638073] Tue, 02 June 2015 02:54 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
jgjeetu wrote on Tue, 02 June 2015 12:53
You cant perform this action, use '<=' instead of '≤'


As Michel said, it depends on the characterset. My client allows to display these characters, however I can store these characters if my database characterset supports it.

For example,

SELECT unistr('1 \2265 2') FROM dual;

UNISTR('1\22652')
-----------------
1 ≥ 2 

SELECT unistr('1 \2264 2') FROM dual;           

UNISTR('1\22642')
-----------------
1 ≤ 2  


Check out http://www.fileformat.info/info/unicode/char/2264/index.htm
Previous Topic: select first row after appying order by for multiple records
Next Topic: SQL & xml
Goto Forum:
  


Current Time: Tue Mar 19 04:17:08 CDT 2024