MaxDB is trimming the trailing spaces

[Former Member]

MaxDB is trimming the trailing spaces

While inserting on (VAR)CHAR columns.

See the following experiment:

create table test (x varchar(20));

insert into test values (' kkq ');

select length(x) from test;

This will show a length of 5.

This occurs when connecting with odbc as well as jdbc.

We are having porting problems because Oracle and DB2 for example

do not trim trailing spaces.

Are there any parameters (server or driver) to alter this behavior

to preserving the trailing spaces?

[lbreddemann]

>

> MaxDB is trimming the trailing spaces

Yes, it does.

> We are having porting problems because Oracle and DB2 for example

> do not trim trailing spaces.

> Are there any parameters (server or driver) to alter this behavior

> to preserving the trailing spaces?

No there is no such thing.

But the question here is of course: why is it necessary to preserve these spaces?

It's a pretty strange form of data modelling...

regards,

Lars