Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 May 2004 @ 08:08:05 GMT


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


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016