[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