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
