Skip to Content.
Sympa Menu

freetds - Re: [freetds] Non western language

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Non western language
  • Date: Fri, 11 Nov 2005 07:19:23 +0100

Il giorno ven, 11/11/2005 alle 13.01 +0900, Horacio Sanson ha scritto:
> Hello,
>
> I have been working with FreeTDS/unixODBC on a linux machine connecting to
> a
> MS SQL 2000 database. All my varchar fields are in japanese and I can
> update/insert records with japanese characters with no problem. Using the
> SQL
> Query Analyser on windows shows the japanese text correctly.
>
> The problem is that I cannot select records from the server as all text
> data
> gets converted to "?" chars. I changed the configuration in all ways I
> could
> think of using diferent char encodings with no luck. Can someone help me
> find
> a way to read japanese text/varchar fields from the database??
>
> Here is my configuration:
>
> # freetds.conf
> [TEST]
> host = 192.168.0.210
> port = 1433
> tds version = 8.0
> client charset = SJIS
>
>
> # odbcinst.ini
> [TDS]
> Description = v0.52 with protocol v4.2
> Driver = /usr/lib/libtdsodbc.so
> UsageCount = 1
>
> # .odbc.ini
> [TEST]
> Driver = TDS
> Description = test database
> Trace = No
> Server = 192.168.0.210

Here use Servername = TEST instead, if you use Server freetds.conf get
not read at all.

> Database = TEST
>
>
> I connect using isql and my system is set to Shift_JIS encoding. I can send
> data to the SQL server and it is stored ok at the server but I cannot later
> retrieve it.
>
> I tried several charsets like UTF-8, Shift-JIS, EUC-JP etc and all of them
> give me "?" chars instead of the japanese characters.
>
>
> regards,
> Horacio
>

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page