Specifies additional options for a data source.In a database window, choose Edit - Database - Properties, click Additional Settings tabThe availability of the following controls depends on the type of database:
Host name
Enter the host name of the server that contains the database, for example ldap.server.com.used for multiple database formats
Port number
Enter the port number for the server that hosts the database.UFI: used for LDAP and MySQL, different default values
MySQL JDBC driver class
Enter the name of the JDBC driver for the MySQL database.UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??)
Character setUFI: seen for dBaseand for text file folder
Select the character set that you want to use to view the database in $[officename]. This setting does not affect the database. To use the default character set of your operating system, select "System".Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes.UFI. copied from shared\explorer\database\11020000.xhp
Oracle JDBC driver class
Enter the name of the JDBC driver for the Oracle database.UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??)
Driver settings
Specify additional driver options.UFI. copied from shared\explorer\database\11020000.xhp
Use catalog for file-based databases
Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.UFI. copied from shared\explorer\database\11020000.xhp
Base DN
Enter the starting point to search the LDAP database, for example, dc=com.copied from shared\explorer\database\11190000.xhp
Maximum number of records
Enter the maximum number of records that you want to load when you access the LDAP server.
Display deleted records as wellUFI: seen for dBase, but Help ID is somewhere else
Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.copied from shared\explorer\database\11030000.xhpIn dBASE format, deleted records remain in the file.To view changes that you make to the database, close the connection to the database, and then reconnect to the database.
IndexesUFI: seen for dBase
Opens the Indexes dialog, where you can organize the table indexes in the current dBASE database.UFI: removed link from extended help text
Text contains headersUFI: the following found for a text file folder, but HELP Ids are somewhere else
Select this check box if the first line of the text file contains field names.copied from shared\explorer\database\11040000.xhp
Field separator
Enter or select the character that separates data fields in the text file.
Text separator
Enter or select the character that identifies a text field in the text file. You cannot use the same character as the field separator.
Decimal separator
Enter or select the character that is used as a decimal separator in the text file, for example, a period (0.5) or a comma (0,5).
Thousands separator
Enter or select the character that is used as a thousands separator in the text file, for example a comma (1,000), or a period (1.000).
File extension
Select the format for the text file. The extension that you select affects some of the default settings in this dialog.