Re[2]: Problems with varchar/text

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