ODBC: Column names are truncated
Imported from http://bugzilla.roxen.com/bugzilla/show_bug.cgi?id=4206
Reported by Marcus Wellhardh wellhard@roxen.com
When using an ODBC connection to an msSQL server the column names are truncated. It is porbably related to the added unicode support.
Example (pike from 4.5.78):
Pike v7.4 release 398 running Hilfe v3.5 (Incremental Pike Frontend)
> object db=Sql.sql("odbc://test:test@groept");
>
> mixed res = db->query("select * from person");
> werror("%O", res);
({ /* 3 elements */
([ /* 6 elements */
".firs":"Yuri",
".last":"Cauwerts",
".pers":"1",
"firs":"Yuri",
"last":"Cauwerts",
"pers":"1"
]),
It has however worked before (pike from 4.0.425):
Pike v7.4 release 340 running Hilfe v3.5 (Incremental Pike Frontend)
> object db=Sql.sql("odbc://test:test@groept");
> mixed res = db->query("select * from person");
> werror("%O", res);
({ /* 3 elements */
([ /* 6 elements */
".firstname":"Yuri",
".lastname":"Cauwerts",
".personid":"1",
"firstname":"Yuri",
"lastname":"Cauwerts",
"personid":"1"
]),