FreeTDS Development Group

[Brian Paquin <brian.paquin AT yale.edu>]

James,

Thanks for replying to the message, but I am afraid tsql is
still using iso646...

A locales.conf file (default) is present in /usr/local/etc/.
Modifying freetds.conf to add:
client charset = ISO-8859-1   or
client charset = ISO_1
have not made a difference.
I have used the GLOBAL section or my own PROD section,
and neither has had an affect.

Enabling logging in freetds.conf, I can see that FreeTDS is
sending requests for iso646...

Am I missing something?

Brian  :)

On May 21, 2007, at 10:07 PM, James K. Lowden wrote:

> > 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

_________________________________________
Brian T. Paquin, ACSA, ACHDS, ACTC, ACDT, ACPT
Yale University
Department of Pathology
brian.paquin AT yale.edu
(203) 785-3691