PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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
place?

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.peppler.org/resume.html