Search code examples
oracle-databaseunicodeplsqlgeorgian

Georgian Unicode in PL/SQL Developer Oracle

When I do select for update and enter Georgian symbols in varchar2 column everything works correctly.

But result of SELECT 'ტექსტი' FROM dual is this ????????

, also

INSERT INTO test (text) VALUES('ტექსტი');

enters ???????? in colomn text

NLS_CHARACTERSET is AL32UTF8

Solution

  • You should set NLS_LANG. It can be done by changing registry key in branch "\HKEY_LOCAL_MACHINE\Software\ORACLE", or by setting environment variable NLS_LANG. Value of NLS_LANG should fit the value of NLS_CHARACTERSET - AL32UTF8 in your case.

    You could also set property "Check for client & server character set mismatch" in PL/SQL Developer - it's located in Tools -> Preferences... -> Oracle -> Options.