Archives of the TeradataForum
Message Posted: Fri, 21 May 2004 @ 09:00:11 GMT
| 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
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.