 |
 |
Archives of the TeradataForum
Message Posted: Fri, 21 May 2004 @ 08:08:05 GMT
| Subj: | | Re: Character SET Latin vs. Unicode |
| |
| From: | | Victor Sokovin |
| | The following SQL creates a column COL_C with data type "CHARACTER SET UNICODE". Is there a way to default to CHARACTER SET LATIN, without
changing the Create syntax? | |
| | fyi, the reason I cannot change the syntax is because the sql is auto-generated by the CRM tool. | |
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.
Regards,
Victor
| |
