Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem putting special sign (e.g. BOM) into varchar2 column

JackKJun 7 2019 — edited Jun 7 2019

Hi All, I want to write string  chr(239)||chr(187)||chr(191) (hex: EFBBBF)  into varchar2 column. The problem is that value written to the column is NULL.

Also the output of select chr(239)||chr(187)||chr(191) from dual; is NULL.

Help! What am I doing wrong?

Regards, Jacek
Comments
Post Details
Added on Jun 7 2019
14 comments
1,602 views