From: | "Poul L(dot) Christiansen" <poulc(at)miba(dot)auc(dot)dk> |
---|---|
To: | FMK <meyer-kassel(at)online-shop-ag(dot)de> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Problems with varchar/text |
Date: | 2000-08-30 14:04:59 |
Message-ID: | 39AD148B.EBB198C5@miba.auc.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
That's funny, I also use Cold Fusion (but on NT with ODBC drivers).
Try using quotes: INSERT INTO billing (billnumber) VALUES ('00086901')
ColdFusion with a native PostgreSQL-Driver? How do you set that up?
FMK wrote:
> I'm using ColdFusion with a native PostgreSQL-Driver. OS is Linux, and
> my insert-statement looks like this:
>
> INSERT INTO billing (billnumber) VALUES (00086901)
>
> > Maybe you have forgot to quote the string.
>
> > Could you mail us the exact SQL that you use to insert the data.
>
> > Are you using ODBC? What OS/app is the client and server?
>
> > FMK wrote:
>
> >> Hi out there,
> >>
> >> I've got a table with a field named "blabla", type is varchar(12).
> >>
> >> Now I want to insert "00083151" into this field, but after the INSERT
> >> the leading zeros are cutted, eg. in the DB is only "83151"
> >>
> >> Same Problem with type text...
> >>
> >> Any Idea how I can get the _complete_ Value with the leading zeros
> >> into the DB ?
> >>
> >> Thanks in Advance !
> >>
> >> Florian
From | Date | Subject | |
---|---|---|---|
Next Message | ghaverla | 2000-08-30 14:06:46 | Re: Re[2]: Problems with varchar/text |
Previous Message | FMK | 2000-08-30 13:55:13 | Re[2]: Problems with varchar/text |