Archives of the TeradataForum
Message Posted: Thu, 21 Oct 2004 @ 18:08:30 GMT
If you have specified it so for all hosts and restarted the database, then yes.
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
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.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|