title: Storing Japanese characters in Teradata
body: <p>I have a SSIS package that pushes data from a SQL database to a Teradata database.  In my SQL database, I have a particular table that stores Japanese characters, which are read in from a file (encoded in UTF 8 format).  The column that holds this data is of type "nvarchar".  Currently, I have no issues viewing the characters in SQL.  However, when I run my package these characters are displaying as junk in teradata.  Even if I do a simple insert with Japanese characters, I cannot view the data.  The column in teradata is of type varchar (CHARACTER SET UNICODE NOT CASESPECIFIC).  I know there is no nvarchar datatype in teradta. Any thoughts on how to store these characters?</p>