[freetds] Status of UTF-8 support in 0.83 dev

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Mon Sep 8 09:30:48 EDT 2008


> 
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3129 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080908/7f07c71d/attachment.bin 


More information about the FreeTDS mailing list