Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: help with inserting text
Date: Feb 18 1998 3:42PM

philip mikal wrote:
> Hello:
> I am a bit confused on how one inserts text into Sybase using DBlib. I have
> data that I am trying to load into my database that looks like:
> µ-ziq|24|129||"America's premiere
>  electronic label, Astralwerks Records, presents the µ-ziq"|astralwerks@car
> I am taking this data from a text file, spliting it apart (pipe delimited, "|")
> into variables and attempting to insert it into my database.  All my columns
> are text datatypes except for two, integers, which in the above example, would
> be "24" and "129".

Are you using 'TEXT' columns in Sybase?
If so, do you expect the fields to be wider than 255 characters?
If not, then 'TEXT' columns are the wrong datatype. You should be
using CHAR or VARCHAR, and using a normal insert call instead
of dbwritetext(), which is really cumbersome to use.

Michael Peppler       -||-  Data Migrations Inc.  -||-