Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: Does DBD::Sybase strip spaces from padded VARCHARs?
Date: Apr 13 2004 8:40PM
On Tue, 2004-04-13 at 12:16, Pickett, Mark J wrote:
> >varchar() values are always truncated of
> >any trailing whitespace when they are inserted to a table.
> But trailing NULLs aren't truncated. This is the problem I was having.
> I was using selected values to create inserts and updates, but the NULLs
> were causing parse errors.
Hmmm - how did you get NULLs to get inserted in the strings in the first
Michael Peppler Data Migrations, Inc.
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html