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

5. ASCII

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.

Regards,

Victor


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

Attachments

Library

Quick Reference