Please note that Sahi's development and support teams do not actively monitor this. This is more a community forum. If you are a Sahi Pro user looking for commercial support, please email support @ with your query.

Problem reading chinese character from excel

PSPS Members
edited December 2013 in Sahi Pro
Hi forum,

Sahi Version : 5.1.0
Excel Version : 2007

I have an excel sheet that contains Chinese values and when I am trying to retrieve those values from excel using select query it is giving as '???'. Is there any solution for this?

This is the data I have in excel
| Seq ID | Name |
| 1 | 汉语漢語 |

Below is my code

var $db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + $workbookLocation + "/" + $workbookName + ";readOnly=false", "","");
var $rsForActions=$"select * from [Sheet1$]");

Output is shown as "1.0","????"



Sign In or Register to comment.