OraFAQ Forum: SQL & PL/SQL » Inserting mathematical symbol ≤ in Oracle table

Home » SQL & PL/SQL » SQL & PL/SQL » Inserting mathematical symbol ≤ in Oracle table (Oracle 11g)

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

Inserting mathematical symbol ≤ in Oracle table [message #638068]

Tue, 02 June 2015 02:12

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

Report message to a moderator

Re: Inserting mathematical symbol ≤ in Oracle table [message #638072 is a reply to message #638068]

Tue, 02 June 2015 02:21

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

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.

Report message to a moderator

Re: Inserting mathematical symbol ≤ in Oracle table [message #638073 is a reply to message #638068]

Tue, 02 June 2015 02:23

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

You cant perform this action, use '<=' instead of '≤'

Report message to a moderator

Re: Inserting mathematical symbol ≤ in Oracle table [message #638080 is a reply to message #638073]

Tue, 02 June 2015 02:39

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

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

Report message to a moderator

Re: Inserting mathematical symbol ≤ in Oracle table [message #638085 is a reply to message #638073]

Tue, 02 June 2015 02:54

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

Report message to a moderator

Previous Topic:	select first row after appying order by for multiple records
Next Topic:	SQL & xml

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 22 23:20:30 CDT 2025