Management Console in Tomcat
Database servers handles Unicode and case-sensitive comparison very differently. The following list
contains recommendations for the supported database systems.
Table 150. Recommendations for Unicode support and case-sensitive comparison
Create the database using CODESET UTF-8
Create the database with utf8_bin collation:
CREATE DATABASE KAPOW_MC COLLATE utf8_bin
We use NVARCHAR2, NCLOB types for Unicode. For case-sensitive comparison ensure
that NLS_COMP is set to BINARY
We use NVARCAR, NTEXT types for Unicode. For case-sensitive comparison create the
database with a Case-Sensitive collation like SQL_Latin1_General_CP1_CS_AS:
We use NVARCAR, NTEXT types for Unicode. For case-sensitive comparison ensure that
the sort order is binary (see sp_helpsort).
The scripts below use "NVARCHAR(255) NOT NULL UNIQUE", due to index
limitations this will not work on an ASE with 2K page size, unless you modify the scripts
to use NVARCHAR(200) NOT NULL UNIQUE (or install on a 4/8/16K page server)
The tables used by the Management Console can be grouped into 3 categories: Platform tables, logging
tables, and data view tables. The platform tables hold information exclusive to the Management Console
such as the uploaded robots and their scheduling information, while the logging and data view tables are
shared with RoboServer.
When the Management Console starts, it will automatically try to create the required platform tables and
logging tables (if not already created by RoboServer). This means that the user account used to access
the database must have the CREATE TABLE and ALTER TABLE privilege. Oracle users also needs the
CREATE SEQUENCE privilege. If this is not possible you can have your Database administrator create
the tables using the scripts below.
Additionally the user must be allowed to SELECT, INSERT, UPDATE, DELETE for the system to work
SQL scripts for Management Console tables
Table 151. SQL scripts for Management Console tables (right-click and choose
Script to Create Tables
Script to Drop Tables