Poco::Data VARCHAR and TEXT types

[Dece]

Hi,

Using Poco::Data library for the first time.
I can successfully connect to a Sybase database using the ODBC SqlServer Testsuite that comes with the download.
My testcase for table creation

Code: Select all

CREATE TABLE Strings (str VARCHAR(32))

, passes successfully but when I try to insert into the table
using

Code: Select all

INSERT INTO Strings VALUES (?)", use(str)

, I get an error back from sybase db server that it is trying to insert TEXT type into VARCHAR field.

I am wondering if there is a way to specify str vector elements are VARCHAR and not TEXT.

Many thanks in advance for your help.

Dece

[alex]

Just guessing (I don't have Sybase test environment set up), but maybe LONG VARCHAR would do the trick.

[Dece]

Thanks Alex. My question here is how do I make my C++ program use string values as VARCHAR instead of TEXT.
At the moment, it seems like Poco is treating std::string as TEXT when I use in the insert sql.

Is there a way in Poco to specify type while doing sql insertion. By that I mean, when I do a record insert, I want to be able to specify the string is a VARCHAR or it is a TEXT.

Thanks again for your help
Dece