Hi, 

I need to export few chinese and japanese characters stored in teradata to a file.

I have tried different options to export data through TPT but i am either not able to see the unicode characters in the generated file or i face the conflicting data length error.

Hi All,
I would like to ask for your help on explaining and elaborating the difference between columns having data types set to LATIN and those set to UNICODE.

One Analyst here can't see Unicode character using a statistics package called Stata that can only connect to TD using unixODBC.

I've been playing with Teradata ODBC Driver for Linux x64 version 15.10. I have installed it and successfully able to connect via tdxodbc64 tool. But unfortunatelly, I wasn't able to connect via a very simple Mono application (Mono runtime 3.12.1).

I'm having an issue with an 'untranslatable character' error. I've read numerous dev forum posts on the topic, reviewed TD documentation, and still can't find a solution.

Teradata 13.10 is rejecting my insert with the error:
 The string contains an untranslatable character. (6706)
Here is my INSERT statement:
Insert Into CCDW_T.UTest (ucol, i) SELECT 'ɂ',578;
This is my CREATE Table:

I'm using VBA and the Microsoft ActiveX Data Objects 2.6 Library to access our Teradata 14.00.05.03 server using Teradata ODBC Driver 15.00.00.01

Hi,
We have some old tables which has Unicode data(Japanese, Chinese, Korean etc..)  but with table defination as Latin for all columns, Which shows in BO report as Junk/ Unreadable character. Now we are trying to add new columns with character set as Unicode using alter statements. The approach we are following is

Hi Experts,
As per one of the requirement , we are making one column as CHARACTER SET UNICODE CASESPECIFIC.
But as we know that in Unicode too we have two types of character sets UTF-8 & UTF-16.
Can we know some how which one  (UTF_8 or UTF-16?) would be created after making the column as UNICODE?
Thanks in advance!

The character is either
'->' (a single character)
or a '?' surrounded by a black diamond.

Whenever I tried translating 
SELECT CHAR2HEXINT('[character]');
I got 'The string contains an untranslatable character '.  Any suggestions on how to translate this character?

Hi,
   Can anyone let me know how to run a Teradata SQL and output the data in UTF-16 format? I am currently using Teradata Studio Express. I am wondering if the default output is UTF-16 or any translations needed.
 
regards
TZ

Hi,
I have a table which has a column where I can find special characters like &Altide; &Abc; etc. The total list of special characters is 110, I identified them using the logic anything between "&" and ";" is a special character and finally cross checked manually. Now I need to find and replace them in my table with space(" ").

I have created a table as follows:
CREATE SET TABLE DUTLSB.TestUnicode ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
Ident VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Serial INTEGER,

my question is about the output of a UNICODE column in BTEQ.

If I select a column defined like this...
   txt VARCHAR(11) CHARACTER SET UNICODE CASESPECIFIC,
.. it is not 11 characters wide , but it is 33 characters wide
(3 times the number of VARCHARs)

The bteq session character set is UTF8: .set session charset 'UTF8';

Hi, I want to use TPT in one of my project and I am facing the following issue,

(I have read http://developer.teradata.com/tools/articles/teradata-parallel-transporter-unicode-usage#comment-17552 and doing things mentioned in that article but something is missing, here are the details)

Hi people...i am sorry if i am posting this in the wrong forum, but please bear with me...
I have a requirement where i need to find out whether a particular column in the table is a unicode or not... any pointers would be of great help. A query if possible is more desirable.

Thanks in advance!!

I'm writing application, which i.a. inserts Unicode strings into Teradata. I don't know how I can see inserted data, to check wheter it was inserted properly. SQL Assitant doesn't support Unicode, I tried in BTEQ command EXPORT DATA FILE=..., but it wrote to file only strange symbols not in Unicode...