Driver does not returns long strings

[realyota]

Just connect to your clickhouse with:

isql -v ClickHouse

CREATE TABLE string_test
(
    `value` String
)
ENGINE = MergeTree
ORDER BY tuple()

insert into string_test(value) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa')

select * from string_test

The result column value is empty.

SQLRowCount returns 1
1 rows fetched

[c10h15n]

Same problem, dude, more than 300 strings

[realyota]

Using libclickhouseodbcw.so as a driver resolved the issue.

[wushiming540]

I have same problem . I install clickhouse-odbc on windows ,and tableau connect clickhouse by odbc, select name, sum(1) from table group by name; when name length longer than 16char, it will be Truncated。 ODBC version clickhouse-odbc-1.1.6-win64.msi。

[kfluous]

yes . 1.1.7-win64.msi still no work. when i connected clickhouse-odbc to tableau and select one table which with MAC column. original string is 00-E0-4C-1B-0A-CB,but i only got 00-E0-4C-1B-0A- in sheet. when name length longer than 16char, it will be Truncated。

[kfluous]

I have same problem . I install clickhouse-odbc on windows ,and tableau connect clickhouse by odbc, select name, sum(1) from table group by name; when name length longer than 16char, it will be Truncated。 ODBC version clickhouse-odbc-1.1.6-win64.msi。

clickhouse-odbc-1.1.6-win64.msi works for me . i think it was caused by #261 (SQL_NO_TOTAL )

[traceon]

With the following Custom SQL via ODBC Unicode driver built from master branch:

select CAST('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa100aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa200aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa300aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa400', 'String') as col

Tableau Desktop (Windows) shows the entire string just fine: