Database

System Language and Charset

Creating a Database

Creating a New Database

To create a new database you have to:

• specify the database name - it's best to use ASCII characters; special national characters may cause complications in networks using different locale;
• specify database file location - preferably on a drive with sufficient free space and in a folder that is protected from undesired access;
• if there are more servers running on a single computer, choose a port number for each database server;
• specify system language and charset - you should decide what special characters will be used in table and other objects names (this choice doesn't effect data stored in the database).

These items have to be set for successful registration of a database on the computer that will run its server. Respective database file will be created during the first launch of this server.

User has to have privileges to edit system registry on Windows operating systems to create new database; when creating a database on Linux user has to have the privilege to edit the /etc/602sql file.

Creating a New Database from 602SQL Development Client

In the root of the control panel tree (602SQL servers item) invoke the popup menu and select Create a New Local SQL Server. By doing so you open the Create a new database window

Administration of a New Database

A newly created database is empty except for the system objects: system tables, users and groups and the schema _sysext containing empty system triggers.

Anonymous user is created in the new database. This user logs on using the name ANONYMOUS or an empty name, and an empty password. Also the EVERYBODY group (a group of all users) and 3 other administrator groups are created (DB_ADMIN, CONFIG_ADMIN and SECURITY_ADMIN).

The anonymous user is a member of all administrator groups in the new database. This is useful in desktop usage (single user mode), where neither users nor privileges are relevant.

Registration of a Database with Existing Database File

If you want to run a server over a database with existing database file, you have to register the database on the computer that will run the server first.

Registration of an existing database is done in the same way as creating new database. The only difference is that you have to select the folder that contains the existing database file.

Database

System Language and Charset