First of all, thanks for your help.
My problem is that I can't retrive Traditional Chinese char from database.
I use SQL2000 with jre built-in ODBC connector and the data type is nvarchar.
Code: Select all
var sql="SELECT account, password, nickname, state FROM member WHERE account ='"+nick+"'";
// value of nickname column is a Traditional Chinese char (nvarchar)
var queryRes=mydb.executeQuery(sql);
if(queryRes.size()>0){
var tempRow=queryRes.get(0);
trace(tempRow.getItem("account")); //correct
trace(tempRow.getItem("nickname")); // "" no content
}
None Traditional Chinese datas are all correct
but value of nickname column can't be retrived ,
and tempRow.getItem("nickname") is "".
(I am sure that nickname column has its value.)
Where is the problem?
regards.
---------------------
alvin3343