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: 9117698869.20000830140934@online-shop-ag.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 !

Florian

Responses

Browse pgsql-novice by date

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