Passwords and earlier versions of Adaptive Server  Overriding the default message destination

Chapter 12: Backing Up and Restoring User Databases

Passwords and character sets

You can load the dump only to another server with the same character set. For example, if you attempt to load a dump from a server that uses an ASCII character set to a server that uses a non-ASCII character set, the load fails because the value of the ASCII password is different from the non-ASCII password.

Passwords entered by users are converted to Adaptive Server’s local character set. Because ASCII characters generally have the same value representation across character sets, if a user’s password is in an ASCII character set, the passwords for dump and load are recognized across all character sets.





Copyright © 2005. Sybase Inc. All rights reserved. Overriding the default message destination

View this book as PDF