Bugs item #2970087, was opened at 2010-03-13 21:40
Message generated for change (Comment added) made by faridz
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2970087&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/ODBC
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Farid Z (faridz)
Assigned to: Sjoerd Mullender (sjoerd)
Summary: ANSI Client clobbered data ::SQLTables
Initial Comment:
I am using an ANSI ODBC client (not Unicode) with latest version of MonetDB
ODBC driver 1.36.01.01 2/24/2010 and I am getting clobbed resultset comparing
demo database loaded with VOC dataset to itself by using Zidsoft CompareData
app.
Does the ODBC driver not support ANSI clients?
----------------------------------------------------------------------
>Comment By: Farid Z (faridz)
Date: 2010-03-15 13:28
Message:
My app is ANSI so I am using narrow calls. So that's not the cause of this
issue. I see the cause of the problem: the driver is returning incorrect
information for ::SQLTables character resultset columns:
rc = SQLColAttribute(hstmt,
nCol,
SQL_DESC_OCTET_LENGTH,
NULL,
0,
NULL,
&pRow->buffer_length);
rc = SQLColAttribute(hstmt,
nCol,
SQL_DESC_LENGTH,
NULL,
0,
NULL,
(SQLLEN*)
&pRow->column_size);
The driver is returning zero for SQL_DESC_OCTET_LENGTH and SQL_DESC_LENGTH
for ::SQLTables character resultsetset columns instead of actual values.
Same thing for ::SQLPrimaryKeys, ::SQLStatistics and ::SQLForeignKeys
resultsets character columns
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2010-03-15 13:03
Message:
The MonetDB ODBC driver only support Unicode and UTF-8. That is to say,
the wide character calls are expected to use UCS-16, and the narrow
character calls are expected to use UTF-8. The driver does not support any
other character sets (well, ASCII since it is a proper subset of UTF-8).
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2970087&group_id=56967
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
