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

Sebastien FLAESCH sf at 4js.com
Mon Sep 8 10:50:39 EDT 2008


Yep that patch works for me, as long as sending data to the server is concerned.
Thanks a lot for this.

Now I ran into another little problem when fetching data back into small char sizes:

Seems that when using a small column size like NCHAR(2), the data is properly insert in the table,
but when fetching back I get NULLs ...???

I will double check if I use properly SQLBindCol() and get back to you.

Seb

ZIGLIO, Frediano, VF-IT 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?
>>
> 
> Try this patch
> 
> freddy77
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list