Re[2]: Problems with varchar/text - Mailing list pgsql-novice

From FMK
Subject Re[2]: Problems with varchar/text
Date
Msg-id 17620437978.20000830145513@online-shop-ag.de
Whole thread Raw
In response to Problems with varchar/text  (FMK <meyer-kassel@online-shop-ag.de>)
Responses Re: Re[2]: Problems with varchar/text  (ghaverla@freenet.edmonton.ab.ca)
List pgsql-novice
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



pgsql-novice by date:

Previous
From: FMK
Date:
Subject: Problems with varchar/text
Next
From: FMK
Date:
Subject: Re[2]: Problems with varchar/text