Re: DB insert Error

Also,
My insert statement is

EXEC SQL INSERT INTO raw_email (id,raw_email) VALUES (1,:ch);

On 8/16/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> On Wed, Aug 16, 2006 at 01:20:08AM -0400, Jasbinder Bali wrote:
> > This is how the array is formed in my C code
> >
> -------------------------------------------------------------------------------------------
> > FILE *fp;
> >
> > while(!feof(fp))
> > {ch[i]=fgetc(fp);
> > if(ch[i]=='\n') lines++; i++; }
> > ch[i-1]='\0';
> > fclose(fp);
> >
> ------------------------------------------------------------------------------
> > and then am inserting ch as a whole in the varchar column in the
> database.
> >
> > Do you want me to append a leading '{' and a trailing '}' to ch??
>
> Do you intend to handle the data as an array in SQL? If not then
> the raw_email column should be declared as varchar or text instead
> of varchar[]. In that case your C code won't need to change.
>
> --
> Michael Fuhr
>