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: Sebastien FLAESCH <sf AT 4js.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Status of UTF-8 support in 0.83 dev
  • Date: Mon, 08 Sep 2008 14:24:56 +0200

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






Archive powered by MHonArc 2.6.24.

Top of Page