Window ODBC display correct string that I see in Alation or SQL Assistant is
TI‑84 Plus C Silver Edition Graphing Calculator Color Display Brand New!
When I attempt to validate my ODBC installation with tdxodbc, the hyphen does not display correctly:
dmasterov @ /Library/Application Support/teradata/client/15.10/bin
Connecting with SQLDriverConnect("Driver=Teradata; DBCNAME=mozart; UID=dmasterov; PWD=*; CharacterSet=UTF8")...
.....ODBC connection successful.
ODBC version = -03.52.0000-
DBMS name = -Teradata-
DBMS version = -14.10.0603 14.10.06.03-
Driver name = -tdata.dylib-
Driver version = -15.10.01.00-
Driver ODBC version = -03.51-
(type quit to terminate adhoc)
Enter SQL string : SELECT auct_titl FROM access_views.dw_lstg_item_cold WHERE item_id = 301142510864;
Executing SQLExecDirect("SELECT auct_titl FROM access_views.dw_lstg_item_cold WHERE item_id = 301142510864;")...
SQL Statement : 1 rows affected.
TI84 Plus C Silver Edition Graphing Calculator Color Display Brand New!
See Hyphen was removed between TI and 84
Have you tried using the driver with your own ODBC application or a full-featured client? This is likely a limitation of the tdxodbc test program rather than the driver.