Details
-
Type:
Problem report
-
Status: Closed
-
Priority:
Trivial
-
Resolution: Fixed
-
Affects Version/s: 5.0.2
-
Fix Version/s: 5.0.3rc1, 5.2.0alpha1, 5.2 (plan)
-
Component/s: Frontend (F), Proxy (P), Server (S)
-
Labels:None
-
Team:Team I
-
Sprint:Sprint 66 (Jul 2020)
-
Story Points:1
Description
Logic for checking character encoding with Oracle DB is wrong in server and frontend.
Oracle has two character set variables that we check: NLS_CHARACTERSET & NLS_NCHAR_CHARACTERSET.
We check that both of these are UTF8, which is wrong.
- Oracle uses UTF8 name for CESU-8. Proper UTF8 encoding is called AL32UTF8.
- We assume that both NLS_CHARACTERSET & NLS_NCHAR_CHARACTERSET have the same value. This may not be the case.
Suggest allowing AL32UTF8 & UTF8 (CESU-8). The latter should be supported for backwards compatibility with existing installations.