Skip site navigation (1) Skip section navigation (2)

Re[2]: Problems with varchar/text

From: FMK <meyer-kassel(at)online-shop-ag(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re[2]: Problems with varchar/text
Date: 2000-08-30 14:16:34
Message-ID: 11321718058.20000830151634@online-shop-ag.de (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks to all of you for your answers !

We're using CF 4.5 on Linux, and there is a Postgres-Driver built in
(the Example-DBs of CF are Postgres-DBs afaik)

Greetings

/florian

> 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



In response to

pgsql-novice by date

Next:From: ghaverlaDate: 2000-08-30 16:11:42
Subject: 7.0.2 regressions testing on Sparc running 2.5.1
Previous:From: ghaverlaDate: 2000-08-30 14:06:46
Subject: Re: Re[2]: Problems with varchar/text

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group