[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,
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.
More information about the unixODBC-support