|
|
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|http://www.caroline.com/astralwerks/muziq/|"America's premiere
> electronic label, Astralwerks Records, presents the µ-ziq"|astralwerks@car
> oline.com|Astralwerks
>
> 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
--
Michael Peppler -||- Data Migrations Inc.
mpeppler@datamig.com -||- http://www.mbay.net/~mpeppler
|
