Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: edwardspl AT ita.org.mo
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem of unicode ( non-english character )
  • Date: Sun, 28 Mar 2004 01:46:48 +0800

"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.






Archive powered by MHonArc 2.6.24.

Top of Page