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 13:55:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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

In response to


pgsql-novice by date

Next:From: Poul L. ChristiansenDate: 2000-08-30 14:04:59
Subject: Re: Problems with varchar/text
Previous:From: Poul L. ChristiansenDate: 2000-08-30 13:30:12
Subject: Re: Problems with varchar/text

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