That is the point of varchar2 fields. If you want to maintain trailing
spaces etc it should be defined as char(20). You will have to watch out if
you use it in conditions and joins etc as in general the trailing stuff is
now important, is this what you really want?

Ken.

-----Original Message-----
From: Carola Begemann [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2002 13:28
To: [EMAIL PROTECTED]
Subject: inserting tailing spaces into Varchar2 field of ORACLE9.2.0
Data Base


Hallo DBI users,
We are using DBI 1.20 together with DBD::Oracle 1.12 to
insert some data into an Oracle 9.2.0.1.0 Database.
No Problems in general but when a field  containes  spaces  or tabs at the 
right end , these are 
truncated.  Do we have to take special care of VARCHAR2 fields ??
the field is defined as
AUMESSAGEDEF  varchar2(150) and may contain NULL
 

Reply via email to