Create SQL Anywhere Database dialog box
Description
Create a local SAP SQL Anywhere database.
Options
User ID
Enter the user ID. The default is DBA.
Password
Enter the password. The default is SQL.
Database Name
Enter the filename and path of the database you are creating.
Click Browse to browse the file system for existing database files.
Prompt for Password
Check during Connect if you want to be prompted to provide
your password when you connect to this database.
Use Transaction Log
Check to record all database activities. The transaction log
plays a key role in backup and recovery.
Log Name
Enter the filename and path of the transaction log that will
be used to record all database activities. If you do not specify
a path, the transaction log is placed in the same directory as the
database file.
Page Size
Specify the page size of your database. Large databases usually benefit
from a large page size.
Collation Sequence
Select a collating sequence, which is used for all string comparisons
in the database. By default, normal ASCII (binary) ordering will be
used for the lower 128 characters. For the upper 128 characters
(the extended characters), characters that are accented forms of
a letter in the lower 128 are sorted to the same position as the
unaccented form. The determination of whether or not an extended
character is a letter is based on code page 850 (multilingual code
page).
Encrypt database
Check to make it much more difficult for someone to decipher
the data using a disk utility to look at the file. File compression utilities
do not work well on encrypted database files.
Case Sensitive Values
Check if you want all names (tables, columns, and so on) to
be case-sensitive, so that, for example, the Empname column is not
the same as the EMPNAME column.
Java Enabled
Check if you use Java in your database. To use Java, you must install
entries for the runtime Java classes in the system tables.
Blank Padding
Check if you want trailing blank spaces to be ignored when making
comparisons. By default, trailing blank spaces are significant when making
comparisons