[freetds] truncated data from query

robert lazarski robertlazarski at gmail.com
Thu Oct 5 09:22:51 EDT 2006


On 10/5/06, ZIGLIO, Frediano, VF-IT <Frediano.Ziglio at vodafone.com> wrote:
>
> I can confirm is a isql problem.
>
> > So could we take a step back for a minute?  You're not trying
> > to implement
> > anything in terms of unixODBC's isql; that's just a testing
> > tool, and just
> > maybe it has this limitation.  What's the target environment?
> >  PHP?  Can
> > you use samples/odbctest.php with your query, and see if the
> > same problem
> > manifests itself?  Something along those lines?
> >
> > The only direct way to test this is to write and debug a little test
> > application in C that executes your query and prints the
> > result.  It would
> > be nice to have our own general-purpose isql-like tool for
> > ODBC; it would
> > help in flushing out bugs (or proving they don't exists).
> > But no one's
> > found the time to do that yet.
> >

Actually isql is my target env ;-) . I'm not using php . Here's what
I'm trying to do:

1) Mimic mysqldump behavior, among others, that generate INSERT
statements from a live db that can be restored - via mssql . I found a
third party stored procedure that can do that.
2) I'm using an ORM tool - java / hibernate but not important here -
that creates a ddl that will drop all tables and fk's, and then create
tables and fk's . At a higher level I use jdbc and the mssql classes
to connect the running program, not freetds.
3) Create the INSERT statements as seen and dump to file, run the ddl,
restore the INSERTs - all via freetds and isql.

So for me, isql / freetds is my batch tool to do mssql admin, without
windows or its tools.  I'm not a windows user, my development is
remote, and to access windows tools I'd have to use rdp. Even with the
windows tools I'd still have to bring the file to a shell to
manipulate it a bit. I've already done a lot of mssql admin via isql -
the only problem so far is the truncation issue.

>
> Or you can enable odbc trace.
>
> freddy77

534 lines for those who wish to look at it:

http://www.braziloutsource.com/random/freetds_trace.log

I know C a bit if that is what is needed.

Thanks!
Robert


More information about the FreeTDS mailing list