Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 21 Oct 2004 @ 18:08:30 GMT

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

Subj:   Re: Changing the default client character set
From:   Victor Sokovin

  I also set the default charset in the dbc.hostsinfo to KANJIEUC_0U. Does this mean that all the clients connecting to this machine have a default characterset set to KANJIEUC_0U?  

If you have specified it so for all hosts and restarted the database, then yes.

  Or can each user have default client charaterset set set to him?  

To override the character set on a user level use DEFAULT CHARACTER SET in CREATE USER.

if so how do I set the default client

  characterset a different value thru a program w/o having to restart the > database.  

I think there is a difference between the client and user levels here which you might explore. You can use dbc.hostsinfo to override the character set for a group of hosts. This change will require the one-off DB restart, though.

Perhaps the best option would be to propagate customized clispb.dat files to the clients?

Just to sum up: the order of precedence for setting the character set on network-attached clients:

1. Application / utility specific explicit commands (you can add them to standard scripts).

2. User's default character set from CREATE USER.

3. clispb.dat

4. HostsInfo


I hope I got it right but consult the Intl Character Set Support manual for the details anyway as the topic might have ramifications, especially with the Asian character sets.



  <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: 23 Jun 2019