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

Problems with varchar/text

From: FMK <meyer-kassel(at)online-shop-ag(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Problems with varchar/text
Date: 2000-08-30 13:09:34
Message-ID: (view raw or flat)
Lists: pgsql-novice
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 !



pgsql-novice by date

Next:From: Poul L. ChristiansenDate: 2000-08-30 13:30:12
Subject: Re: Problems with varchar/text
Previous:From: S.A.PamungkasDate: 2000-08-30 02:13:33
Subject: Re: destroying db / closing access

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