FreeTDS Development Group

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

Sebastien FLAESCH wrote:
> 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>  '

Sorry was a bit confusing: I get these 18 blanks when using a SQL_NCHAR,
not when using SQL_NVARCHAR of course.

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