Complile package that has unicode character

[hungud]

My package have some codes as below:

decode(a.type_connection, 0, 'Bay thẳng', 'Nối chuyến')

But I compile package and review it:

--> decode(a.type_connection, 0, 'Bay th?ng', 'N?i chuy?n')

Please help me how to fix it.

Thanks for your reading

 

[Marco Kalter]

You will need to set the client character set to UTF8. You can do this by modifying the NLS_LANG setting in the Oracle Registry, or specifically for PL/SQL Developer in the Params.ini file in the PL/SQL Developer installation directory. Add a line like this:

NLS_LANG=AMERICAN_AMERICA.UTF8

Your language and territory can differ of course.