Hi,
while trying to use SAPDB as OTRS database I ran into some problems:
If you use VARCHAR without value, how long can it be?
SAPDB only knows about VARCHAR with a defined value, otherwise its length
is 1.
The other problem is:
CREATE TABLE session
(
id serial,
session_id VARCHAR (120) NOT NULL,
value VARCHAR (1000) NOT NULL,
PRIMARY KEY(id),
UNIQUE (session_id)
)
the name "value" is a reserved identifier in SAPDB. So would it be
possible to change this sometime?
CU,
Wolfgang