MAC ODBC does not handle Unicode

Connectivity
Teradata Employee

MAC ODBC does not handle Unicode

MAC ODBC doesn't handle UNICODE correctly.  It just removed none plain text character. Does anybody have a trick to fix it?

Below are conducted test:

MAC terminal handle . For example, can display the Euro sign:

$ echo -e '\xe2\x82\xac'




Moreover, locale reveals that everything is set to en_US.UTF-8 and iterm2 has the character encoding set to Unicode (UTF-8).

One of the Unicode value that creates the problem is  U+2011, a non breaking hyphen. Oct/dec/hex 
020021 8209 0x2011 ‑


 

Window ODBC display correct string that I see in Alation or SQL Assistant is 

 

TI84 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]: 1 rows affected.

AUCT_TITL

TI84 Plus C Silver Edition Graphing Calculator Color Display Brand New! 


 

See Hyphen was removed between TI and 84


 



Tags (1)
1 REPLY
Teradata Employee

Re: MAC ODBC does not handle Unicode

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.