The Collation utility
82
The Collation utility
With the Collation utility, you can extract a collation (sorting sequence) into
a file suitable for creating a database using a custom collation.
The file that is produced can be modified and used with Sybase Central or
the
-z option of
dbinit
to create a new database with a custom collation.
You must change the label on the following line in the collation file. If you
do not, the custom collation will conflict with the original collation on which
it is based.
Collation label (name)
$ For more information on custom collating sequences, see "Creating a
database with a custom collation" on page 326 of the book ASA User’s
Guide.
You can access the Collation utility in the following ways:
♦ From Sybase Central
♦ From the system command line, using the
dbcollat
command-line utility
Extracting a collation using Sybase Central
v To use the Collation utility from Sybase Central:
1 Open the Utilities folder in the left panel.
2 Double-click Create a Custom Collation in the right panel. The Custom
Collation wizard appears.
3 Follow the instructions in the wizard.
Tip
You can also access this wizard by clicking Tools➤Adaptive Server
Anywhere➤Create a Custom Collation.
The dbcollat command-line utility
dbcollat [
switches
]
output-file
Syntax
To Next Page
Loading...