Emojis Inserted Into UTF8 Database Using NLS_LANG=.UTF8 Do Not Display Correctly From JDBC
(Doc ID 3007408.1)
Last updated on FEBRUARY 28, 2024
Applies to:
JDBC - Version 12.2.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
From a C/C++ application, or from SQL*Plus, emojis are inserted into a database that uses the UTF8 database character set.
When the application specifies NLS_LANG=.AL32UTF8 when performing these inserts, the JDBC driver is able to display them correctly when selecting them later.
However, when the application specifies NLS_LANG=.UTF8 instead, the JDBC driver displays garbage.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |