Client encoding problem

[shishkov]

Hi. Client's nls_lang - AMERICAN_AMERICA.CL8MSWIN1251, database's NLS_CHARACTERSET - AL32UTF8. I created a test application. I put TOracleData on a form, set it's sql to
"select
'йцукее' as "工作允许剂量",
'关闭时间' as "关闭时间"
from
dual"

and connected data set to TDBGrid. Result is ? instead of chinese characters.
When i executed the above sql in sqldeveloper connected to the database with the same tnsname as in test applicatiob - everything is ok.
What i'am doing wrong?

Thank you

 

[Marco Kalter]

You'll probably want to set NLS_LANG to AMERICAN_AMERICA.UTF8 if you want to execute SQL statements with Unicode text.