17 Feb
2003
17 Feb
'03
11:40 a.m.
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