SQL Builder with UNICODE

Scriptcase 9 General
#1

I found problem to display UNICODE text in Scriptcase. I tried to use SQL builder to test the SQL statements:

SELECT N’香’;

It can display 香 in the result below

If I use

SELECT NCHAR(UNICODE(‘香’));

It will display ? in the result page

What’s going on? This is same with my project to select data from MSSQL, even though I set the project and charset to UNICODE.