[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