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

Sebastien FLAESCH sf at 4js.com
Mon Sep 8 08:24:56 EDT 2008


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
> 




More information about the FreeTDS mailing list