Specifies additional options for a data source.
In a database window, choose Edit - Database - Properties, click Additional Settings tab
The availability of the following controls depends on the type of database:
Enter the host name of the server that contains the database, for example ldap.server.com.
Enter the port number for the server that hosts the database.
MySQL JDBC driver class
Enter the name of the JDBC driver for the MySQL database.
Select the character set that you want to use to view the database in LibreOffice. 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.
Oracle JDBC driver class
Enter the name of the JDBC driver for the Oracle database.
Specify additional driver options.
Use catalogue for file-based databases
Uses the current data source of the catalogue. 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.
Enter the starting point to search the LDAP database, for example, dc=com.
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 well
Displays all the records in a file, including those marked as deleted. If you mark this check box, you cannot delete records.
In 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.
Opens the Indexes dialogue box, in which you can organise the table indexes in the current dBASE database.
Text contains headers
Mark this check box if the first line of the text file contains field names.
Enter or select the character that separates data fields in the text file.
Enter or select the character that identifies a text field in the text file. You cannot use the same character as the field separator.
Enter or select the character that is used as a decimal separator in the text file, for example, a dot-on-the-line (0.5) or a comma (0,5).
Enter or select the character that is used as a thousands separator in the text file, for example a comma (1,000), or a dot-on-the-line (1.000).
Select the format for the text file. The extension that you select affects some of the default settings in this dialogue box.