Saving special characters like the not equal sign(≠) in a varchar2 field
874062Jul 7 2011 — edited Jul 8 2011How do you escape the not equal symbol (*≠*) when you are trying to insert into a varchar2 column? The unicode value for the symbol *≠* (not equal sign) is 2260. My query saves(updates) out to the database when I do the following update query:
update provenircl.lkp_universal_code SET DESCRIPTION = '77 - Commercial Loans (all new loans, Officer # ≠ Workout)' where code = '77' and source_type = 'CLASSCD';
I tried escaping out and using the unicode value but that didn't work either. I am not sure if I formatted it correctly.
update provenircl.lkp_universal_code set description = '77 - Commercial Loans (all new loans, Officer # \u2260 Workout)' where code = '77' and source_type = 'CLASSCD';
The column DESCRIPTION value gets saved but when I review the data it look an upside down question mark as seen below:
Query: select description from provenircl.lkp_universal_code where code = '77' and source_type = 'CLASSCD';
77 - Commercial Loans (all new loans, Officer # ¿ Workout)
I am using Oracle 10g - version 10.1.0.2.0