Re: Problem with creating table and insert data

2017-12-28 Thread slava.koptilin
Hi, Yes, if you need storing variable-length character data then SQL_LONGVARCHAR is a good choice. As I mentioned above, the full list of supported types is available here: https://apacheignite-sql.readme.io/docs/odbc-data-types Thanks! -- Sent from:

Re: Problem with creating table and insert data

2017-12-27 Thread bagsiur
Thank you very much. This is the answer. So, I understend that in ODBC best equivalent of TEXT type is LONGVARCHAR? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Problem with creating table and insert data

2017-12-27 Thread slava.koptilin
Hello, It looks like 'text' data type is not supported by ODBC driver [1]. Please try the following DDL command 'CREATE TABLE test_md5 (id int PRIMARY KEY, userkey varchar(255), server varchar(255), tsession varchar(255), tpost varchar(255), tget varchar(255), adddate int)'; [1]