[unixODBC-support] Re: Chinese encoding issue

Martin J. Evans martin.evans at easysoft.com
Wed Feb 27 21:13:34 GMT 2008


Yu-Hui Jin wrote:
> Hi, there,
>
> I set up unixODBC and freetds on my Linux box to talk to MS SQL Server 
> 2000 (and 2005) hosts.   The data in those databases contain Chinese 
> texts encoded in GB2312.
>
> Everything seems to be working.  I can run both tsql and isql with the 
> same statement to retrieve data from one of the test SQL Server 
> databases.  Then I found tsql returns the correct Chinese characters 
> (for a column value) but isql  returns garbled data which looks like 
> "?????, ???".   So I suspect it's unixODBC messed up with the data.
>
> Does anyone know what should I do to fix this?
>
>
> Many thanks,
>
> Yuhui
isql is an ASCII app. You will need to use uisql (or whatever it is 
called - can't remember off the top of my head). Both isql and uisql are 
really demo apps although I would not be surprised if someone is using 
them for something useful.

Martin



More information about the unixODBC-support mailing list