freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "James K. Lowden" <jklowden AT freetds.org>
- To: TDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] FW: Character sets?
- Date: Mon, 21 May 2007 22:07:00 -0400
> From: Brian Paquin
> Sent: Friday, May 18, 2007 2:59 PM
>
> I have installed FreeTDS 0.64 (/usr/local/) on a Mac 10.4.8 Server box,
> and configured freetds.conf (/usr/local/etc/) to add entries for our
> Sybase 12.5 servers (using TDS protocol 5.0).
>
> When using tsql to establish a connection, I see:
> -------
> intranet:/usr/local/bin user$ ./tsql -SPROD -Ujohn -Psmith
> locale is "C"
> locale charset is "US-ASCII"
> Msg 2409, Level 11, State 2, Server rs6000_prd, Line 0
> Cannot find the requested character set in Syscharsets: name =
> 'iso646'.
>
> Msg 2411, Level 10, State 1, Server rs6000_prd, Line 0
> No conversions will be done.
>
> 1>
> ---------
> The database admin says the server uses "iso_1" (same as in
> locales.conf)
I believe that because your locale is defined as "US-ASCII", FreeTDS is
requesting the Sybase server deliver its data as ASCII. iso646 is
Sybase's name for ASCII, but apparently it's not installed on your system.
Which isn't too surprising; iso_1 is a fine ASCII superset.
You could set up your locale or simply put "client charset = ISO-8859-1"
in freetds.conf. That should clear up the warning. You can check the top
of the TDSDUMP log to make sure.
> I can query the database at this point, but I can't connect to the
> database via PHP... and I'm concerned the character sets are the reason.
I doubt the charset issue would interfere with data delivery. You just
get straight-though, unconverted character data, which is just fine for
English.
HTH.
--jkl
-
Re: [freetds] FW: Character sets?,
James K. Lowden, 05/21/2007
-
Re: [freetds] FW: Character sets?,
Brian Paquin, 05/22/2007
-
Re: [freetds] FW: Character sets?,
James K. Lowden, 05/22/2007
- Re: [freetds] FW: Character sets?, Brian Paquin, 05/22/2007
-
Re: [freetds] Character sets?,
Daniel Fazekas, 05/22/2007
- Re: [freetds] Character sets?, Brian Paquin, 05/22/2007
-
Re: [freetds] FW: Character sets?,
James K. Lowden, 05/22/2007
-
Re: [freetds] FW: Character sets?,
Brian Paquin, 05/22/2007
Archive powered by MHonArc 2.6.24.