I've checked the scenario with the pure ODBC and it seems like the issue is not with the ODBC driver, as it lets you insert and select varchar data of any length, but with the tools, which truncate any data that user passes to column size, which set to 64 by default for variable length columns.
I've created a ticket [1] for this issue so you can track our progress with it. [1] - https://issues.apache.org/jira/browse/IGNITE-7362 Best Regards, Igor On Tue, Jan 9, 2018 at 11:06 AM, bagsiur <[email protected]> wrote: > Yes, and maybe will difficult to find solution on this error: > https://bugzilla.xamarin.com/show_bug.cgi?id=37368 > > If will be nessesery I can try to prepare VS 2017 and compile it one more > time... > > So, here is my simple script: > > <?php > > ini_set("display_errors", 1); > error_reporting(E_ALL); > > try { > > $ignite = new PDO('odbc:Apache Ignite'); > $ignite->setAttribute(PDO::ATTR_ERRMODE, > PDO::ERRMODE_EXCEPTION); > > $sql = 'CREATE TABLE IF NOT EXISTS test_md5 (id int > PRIMARY KEY, userkey > LONGVARCHAR, server LONGVARCHAR, tsession LONGVARCHAR, tpost LONGVARCHAR, > tget LONGVARCHAR, adddate int) WITH > "atomicity=transactional,cachegroup=somegroup"'; > $ignite->exec($sql); > > for($i=0; $i <= 10; $i++){ > $dbs = $ignite->prepare("INSERT INTO test_md5 (id, > userkey, server, > tsession, tpost, tget, adddate) VALUES ($i, 'Lorem ipsum dolor sit amet, > consectetur adipiscing elit, sed do elit, sed', 'b', 'c', 'd', 'e', 1)"); > $dbs->execute(); > } > > > } catch (PDOException $e) { > print "Error!: " . $e->getMessage() . "\n"; > die(); > } > > ?> > > If TEXT is a little bit longer I have error like in my second post. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
