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!

Storing Emoji in oracle database

3597207Dec 9 2019 — edited Dec 9 2019

Hi.

In the database i see we using these settings for nls_database_parameters

NLS_CHARACTERSET = WE8MSWIN1252

NLS_NCHAR_CHARACTERSET = AL16UTF16

i am trying to store emoji in a table and earlier datatype for that particular column was varcahr2(4000) but it stores values like ¿ for emoji.

to support unicode do i have to store in Nvarchar2 or NCLOB ? if yes is it always going to store with such characters in database ?

Also is their a way i can see the actual emoji by returning that column value in my sql developer.

more important i am working in two chat apps. so i want to transmit the right emoji to second app so it can display the right emoji.

currently it displaying special characters like ¿ on the other app.

Thanks

Added on Dec 9 2019

4 comments

9,217 views