freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

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

Re: [freetds] Status of UTF-8 support in 0.83 dev, Sebastien FLAESCH, 09/01/2008
- Re: [freetds] Status of UTF-8 support in 0.83 dev, ZIGLIO, Frediano, VF-IT, 09/02/2008
  - Re: [freetds] Status of UTF-8 support in 0.83 dev, Sebastien FLAESCH, 09/08/2008
    - Re: [freetds] Status of UTF-8 support in 0.83 dev, ZIGLIO, Frediano, VF-IT, 09/08/2008
      - Re: [freetds] Status of UTF-8 support in 0.83 dev, Sebastien FLAESCH, 09/08/2008
        
        Re: [freetds] Status of UTF-8 support in 0.83 dev, ZIGLIO, Frediano, VF-IT, 09/08/2008
      - Re: [freetds] Status of UTF-8 support in 0.83 dev, Sebastien FLAESCH, 09/08/2008
        
        Re: [freetds] Status of UTF-8 support in 0.83 dev, Sebastien FLAESCH, 09/08/2008
        
        Re: [freetds] Status of UTF-8 support in 0.83 dev, ZIGLIO, Frediano, VF-IT, 09/08/2008
        
        Re: [freetds] Status of UTF-8 support in 0.83 dev, ZIGLIO, Frediano, VF-IT, 09/08/2008
        
        Re: [freetds] Status of UTF-8 support in 0.83 dev, Sebastien FLAESCH, 09/08/2008
        
        Re: [freetds] Status of UTF-8 support in 0.83 dev, Sebastien FLAESCH, 09/08/2008
        
        Re: [freetds] Status of UTF-8 support in 0.83 dev, ZIGLIO, Frediano, VF-IT, 09/09/2008
        Re: [freetds] Status of UTF-8 support in 0.83 dev, Sebastien FLAESCH, 09/09/2008
        Re: [freetds] Status of UTF-8 support in 0.83 dev, ZIGLIO, Frediano, VF-IT, 09/09/2008
        
        Re: [freetds] Status of UTF-8 support in 0.83 dev, ZIGLIO, Frediano, VF-IT, 09/09/2008
        [freetds] Freetds slow on large inserts, Marco Baurdoux, 09/09/2008
        Re: [freetds] Freetds slow on large inserts, ZIGLIO, Frediano, VF-IT, 09/09/2008
        
        Re: [freetds] Freetds slow on large inserts, Reid, Roger L., 09/09/2008