Installing online help for Transact-SQL syntax
24
Changing the default character set and sort order
You can change the default character set by using the
charset
utility. You can
use this utility only from the UNIX shell, so you must open a Terminal window.
The utility is found at /Applications/Sybase/System/ASE-12_5/bin/charset. To
change Adaptive Server’s defaults:
1
Run the
charset
utility to add the character set to Adaptive Server’s system
catalogues.
2
Execute the
sp_configure
stored procedure to set the default character set.
3
Restart the server. The server comes up, performs any necessary
reconfiguration it needs to do internally, and then shut itself down. You can
then restart it.
Note
Perform these steps before you add any user data to the Adaptive Server.
If your server contains data, follow the procedure outlines in the System
Administration Guide to save and restore it.
Changing the default language
Client programs may require messages to be delivered in in a language other
than U.S. English. If this is the case, run the
sp_modifylogin
stored procedure to
specify which language is preferred. The specified language must first be
installed by the System Administrator using the
langinstall
utility, found in
/Applications/Sybase/System/ASE-12_5/bin/langinstall.
Installing online help for Transact-SQL syntax
This section provides instructions for installing online help for Transact-SQL
syntax.
Online syntax help: sp_syntax
There is a script for installing the syntax help database, sybsyntax. You can
retrieve this data with the
sp_syntax
system procedure. The script is located in
$SYBASE/$SYBASE_ASE/scripts/ins-syn-sql.
Summary of Contents for Adaptive Server Enterprise 12.5.x
Page 1: ...Quick Installation Guide Adaptive Server Enterprise 12 5 x Mac OS X...
Page 10: ...x...
Page 50: ...SySAM administration 40...
