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?
> 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 !
In response to
pgsql-novice by date
|Next:||From: FMK||Date: 2000-08-30 13:55:13|
|Subject: Re: Problems with varchar/text|
|Previous:||From: FMK||Date: 2000-08-30 13:09:34|
|Subject: Problems with varchar/text|