Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Status of UTF-8 support in 0.83 dev
  • Date: Mon, 8 Sep 2008 15:30:48 +0200

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

Attachment: smime.p7s
Description: S/MIME cryptographic signature




Archive powered by MHonArc 2.6.24.

Top of Page