Re: Status of UTF-8 support in 0.83 dev

> 
> 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?
> 

Mmm.... If ColumnSize (SQLBindParameter) is 20 and column size declared is 40... it's a
BUG :)
Yes, code is at src/tds/query.c, tds_get_column_declaration, probably is better to reuse
tds_fix_column_size at this point and divide by 2 for "N-types" (NCHAR/NVARCHAR/NTEXT) so
to be 100% consistent

freddy77

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds