Insert ≥ or ≤

[Joachim F]

Hello everyone,

I'm trying to insert a string with the character "≤" into a table, but when I select after, I get "=", and it's indeed "=" in the database.

When I do the same insert on the server locally, with sqlplus, it works fine, and when I select it with PL/SQL Developper, I get "≤"... Some UTF8 issue?? I check in the Preferences the parameter Unicode, and it's well enabled... Is there another option hidden somewhere?? Thx in advance!

 

[Joachim F]

Hmm, even the forum doesn't want my "greater or equal" and "lesser or equal"

 

[Marco Kalter]

Can you go to Help > Support Info and copy the text from the "Info" tab page?

 

[Joachim F]

Here we go:

PL/SQL Developer
Version 11.0.4.1774
01.101712 - 50 user license
Service Contract: 1/06/2016
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4.194.304 kB (1.629.144 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (1.861.708 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Dual
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\joafra\AppData\Roaming\PLSQL Developer\Preferences\joafra\default.ini

License File
C:\Program Files (x86)\PLSQL Developer\aalf.dat

Debug file
C:\Program Files (x86)\PLSQL Developer\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files (x86)\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
...

Homes
OraClient11g_home1 (C:\oracle\product\11.2.0\client)

DLLs
C:\oracle\product\11.2.0\client\bin\oci.dll

TNS File
C:\oracle\product\11.2.0\client\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\oracle\product\11.2.0\client\bin\oci.dll
OCI: version 11.1
Oracle Database 12c Standard Edition Release 12.1.0.2.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: DUTCH_THE NETHERLANDS.WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Monitor
Id = 0
Primary = True
Handle = 327681
Left = 0
Top = 0
Width = 1280
Height = 1024

MainFormOnTaskbar = False