Archives of the TeradataForum

Message Posted: Fri, 21 May 2004 @ 09:00:11 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Character SET Latin vs. Unicode

From:		Dieter Noeth

Victor Sokovin wrote:

You could change the default character set for the TD user that creates tables in the CRM tool. The command should be something like

     MODIFY USER CRM_user_name as DEFAULT CHARACTER SET LATIN ;

Of course, all the temp tables will use LATIN then. I don't know whether it will be OK for the rest of the CRM application. As far as I know there is no table-by-table solution in the situation you have described.

If you look at the original post, the character column already had a Latin charset. The Unicode was caused by the literal value: all literal values are treated as UNICODE VARCHARs.

So there's AFAIK no way to switch to Latin without modifying the statement.

Dieter