FreeTDS Development Group

[Luciano Pacheco <lucmult AT gmail.com>]

On Fri, May 7, 2010 at 1:49 PM, Craig A. Berry <craigberry AT mac.com> wrote:

>
> On May 7, 2010, at 10:13 AM, Luciano Pacheco wrote:
>

[...]

 > Here is the patch:
> >
> https://lists.ibiblio.org/sympa/arc/freetds/attachments/20100430/244dd8a5/attachment.obj
> >
> > I will try the patch with more time.
> >
> > I read the patch and don't understand why use ISO-8859-1 as default
> > encoding, AFAIK the best choice today is use the UTF-8, that can
> > handle more
> > use cases, but I'm very new to freetds.
>
> I believe falling back to ISO-8859-1 emulates ancient behavior from
> the commercial clients, but I'm not sure.
>

I back from my bugged conf. (utf-8 in lower case) and tried the patch.

# Without confs. from freetds.conf
# the option -o dump file didn't work :-/
$ src/apps/tsql  -H 172.16.182.128 -p 1433 -U lucianopacheco -P lerolero -o
dump file = /tmp/freetds.log
Warning: invalid option 'go' found: "go" treated as simple SQL
locale is "pt_BR.utf-8"
locale charset is "utf-8"
using default charset "ISO-8859-1"
Msg 20017, Level 9, State -1, Server OpenClient, Line -1
Unexpected EOF from the server
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
There was a problem connecting to the server

But if I export: "export TDSVER=8.0" works ok.

# using confs. from freetds.conf that has "tds version = 8.0"
$ src/apps/tsql  -S MACLUCK -U lucianopacheco -D dbServicos  -P lerolero
-I /opt/local/etc/freetds/freetds.conf
locale is "pt_BR.utf-8"
locale charset is "utf-8"
using default charset "ISO-8859-1"
Default database being set to dbServicos
1> select * from Precos;
2> go
# Works ok :-)

Thanks,
-- 
Luciano Pacheco
blog.lucmult.com.br