FreeTDS Development Group

[Sebastien FLAESCH <sf AT 4js.com>]

Frediano,

I have just tested latest sources with SQLBindParameter using:

 ParameterType  = SQL_WVARCHAR
 ColumnSize     = 2

It works now but I just wanted to confirm something with you:

When binding with SQL_VARCHAR (no W) with ColumnSize=20, SQL Server
Profile trace shows the parameter for sp_prepare is defined as:

   @P1 VARCHAR(20)

When binding with SQL_WVARCHAR, I see following type:

   @P1 NVARCHAR(40)
                ^^----!!!

Even if ColumnSize=20 ...

Why 40 and not 20? Is this expected?

It appears that the sp_execute call uses the correct number of blanks:

  N'ab   <18 blanks>  '

So I would rather expect:

   @P1 NVARCHAR(20)

for sp_prepare ... no?

Can you double check that please?

Thanks a lot for your help ;-)
Seb

ZIGLIO, Frediano, VF-IT wrote:
> > Hi all,
> >
> > Any chance to get this fixed soon?
> >
> > For now I am blocked and cannot continue my developments and our
> > customer is waiting for this fix...
> >
> > If you point me to the piece of code (in libTDS and ODBC) I can
> > have a look...
> >
> > Thanks a lot.
> > Seb
>
> Yes, I committed the fix 4 days ago.
>
> freddy77
>
> ....
> > > libTDS should pass on_server.column_size while ODBC should 
> > fill it... fix waiting... (this
> > > evening I'm quite busy)
> > >
> > > freddy77
> > >
> > >
> > > ------------------------------------------------------------------------
> > >
> > > _______________________________________________
> > > FreeTDS mailing list
> > > FreeTDS AT lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds