No, this is not a bug. varchar automatically strips trailing spaces, so it's an Oracle thing. I would recommend familiarizing yourself with the ORacle data types. Char is probably what you want to use.
Ilya -----Original Message----- From: Jeff Hunter To: [EMAIL PROTECTED] Sent: 2/28/02 9:40 AM Subject: Whitespace being truncated with Oracle I am using perl 5.6.1 on Solaris 2.8. My DBI version is DBI-1.21 and my DBD version is DBD-Oracle-1.12. My Oracle version is 8.1.7.2 and my Oracle OCI version is 8.1.7.0.0. I have setup a query that retrieves VARCHAR2(10) values from a table into a bound variable. The values in the table are right padded with spaces. When I retrieve the values, I can print them out exactly as they are in the table. However, when I insert them into another table, the spaces at the end of the variable are stripped off. I think the spaces are being truncated in the bind_param method. Is this a bug with the DBD I am using?
