The Initialization utility
100
’Smith’
’Smith ’
would be treated as equal in a database created with blank-padding.
This option is provided for compatibility with the ISO/ANSI SQL standard,
which is to ignore trailing blanks in comparisons. The default is that blanks
are significant for comparisons.
$ For related information, see "ANSINULL option" on page 172.
Case sensitivity for all string comparisons (–c) For databases created
with this option, all values are considered to be case sensitive in comparisons
and string operations. Identifiers in the database are case insensitive, even in
case sensitive databases.
This option is provided for compatibility with the ISO/ANSI SQL standard.
The default is that all comparisons are case insensitive.
User ID and password
All databases are created with at least one user ID, DBA, with password
SQL. If you create a case-sensitive database, all passwords are case
sensitive. User IDs, like other identifiers, are case insensitive even in case
sensitive databases.
Encrypt the database (–e) Encryption makes it more difficult for
someone to decipher the data in your database by using a disk utility to look
at the file. File compaction utilities cannot compress encrypted database files
as much as unencrypted ones.
The encryption used is intended only to keep data hidden in the event of
casual direct access of the database file.
Do not install Sybase jConnect support (–i) If you wish to use the
Sybase jConnect JDBC driver to access system catalog information, you
need to install jConnect support. Use this switch if you wish to exclude the
jConnect system objects. You can still use JDBC, as long as you do not
access system information. If you want, you can add Sybase jConnect
support at a later time using Sybase Central.
Do not install Sybase runtime Java classes (–j) If you wish to use
Java in your database, you must install the Sybase runtime Java classes. By
default, these classes are installed. The runtime classes add several
megabytes to the size of a database, so if you do not intend to use Java
classes, you can specify the
-j switch to avoid installing them. If you want,
you can add Sybase runtime Java classes at a later time using Sybase Central.
To Next Page
Loading...