Overview
Features
Download
Documentation
Community
Add-Ons & Services

SQLServer & VARCHAR in WHERE clause

Please post support and help requests here.

SQLServer & VARCHAR in WHERE clause

Postby rAndom69 » 18 Jul 2013, 13:53

Poco (1.4.6) ODBC parameter binder uses SQL_LONGVARCHAR.
This however does not seem to be SQLServer express compatible (however only in WHERE clause where source field is VARCHAR or CHAR - for example INSERTs are working fine), SQL_VARCHAR is.

To make myself clear
INSERT INTO Table (VarcharColumn) VALUES (?), use(std::string) works
SELECT * FROM Table WHERE VarcharColumn = ?, use(std::string) does _not_ work

Per http://msdn.microsoft.com/en-us/library ... 85%29.aspx this type has no mapping in SQL-92 (thus I would expect it to work in less cases than "adequate" SQL_VARCHAR).
Is there a reason (different database which _needs_ SQL_LONGVARCHAR) for this ? Or could I safely patch Poco for my reasons ?
rAndom69
 
Posts: 1
Joined: 17 Jul 2013, 10:04

Return to Support

Who is online

Users browsing this forum: cc90202 and 2 guests