[freetds] Problem of unicode ( non-english character )

edwardspl at ita.org.mo edwardspl at ita.org.mo
Sat Mar 27 12:46:48 EST 2004


"James K. Lowden" wrote:

> On Sat, 27 Mar 2004, edwardspl at ita.org.mo wrote:
> > "Lowden, James K" wrote:
> > > 1.  Make sure libiconv is installed.
> >
> > How can I sure libiconv is installed ?
>
> Log in to the FreeTDS machine at a shell prompt.  Try:
>
>         $ iconv -l
>
> That should list the character sets that your iconv(1) understands, and
> prove it's installed.  To find the library location, you could try
> something like this:
>
>         $ ldd $(command -v iconv)
>         /usr/pkg/bin/iconv:
>                  -liconv.2 => /usr/pkg/lib/libiconv.so.2
>                  -lc.12 => /usr/lib/libc.so.12
>
> As you can see, my libiconv is in /usr/pkg/lib.
>
> If that's not enough information for you, perhaps your friendly local
> system administrator could help?
>
> > Does UTF-8 support the function of ( convert the charset of unicode )
> > including multi-language ( english and non-english ( eg : chinese ) ) ?
>
> http://www.freetds.org/userguide/nonwestern.htm
> http://www.freetds.org/userguide/aboutunicode.htm
> http://www.freetds.org/userguide/unicodeutf.htm
>
> If you have questions after reviewing these pages, please ask.
>
> > > 6.  Test with tsql.  If it doesn't work "export TDSDUMP=/tmp/tdsdump",
> > > run tsql again, and look at the log.  It will tell you if iconv was
> > > engaged correctly.  If it's not clear, send the log here.
> >
> > Sorry, how to test with tsql ?
> > Just type "export TDSDUMP=/tmp/tdsdump" under Linux System ( shell
> > prompt ) ?
>
> That's right.
>
>         $ export TDSDUMP=/tmp/freetds.log
>         $ tsql -S servername -U username -P password
>
> That will generate a log file named "freetds.log" in the /tmp directory.

Dear jkl,

Would you mind to tell me how to compile freetds for connecting with php and
MS-SQL, then the problem of charset of unicode ( iconv function of freetds )
can't be fixed ?

Many thank for your help !

Edward.





More information about the FreeTDS mailing list