Problems with varchar/text - Mailing list pgsql-novice

From FMK
Subject Problems with varchar/text
Date
Msg-id 9117698869.20000830140934@online-shop-ag.de
Whole thread Raw
List 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



pgsql-novice by date:

Previous
From: "S.A.Pamungkas"
Date:
Subject: Re: destroying db / closing access
Next
From: FMK
Date:
Subject: Re[2]: Problems with varchar/text