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

Re: Problems with varchar/text

From: "Poul L(dot) Christiansen" <poulc(at)miba(dot)auc(dot)dk>
To: FMK <meyer-kassel(at)online-shop-ag(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problems with varchar/text
Date: 2000-08-30 13:30:12
Message-ID: 39AD0C61.FD0D21B7@miba.auc.dk (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: FMKDate: 2000-08-30 13:55:13
Subject: Re[2]: Problems with varchar/text
Previous:From: FMKDate: 2000-08-30 13:09:34
Subject: Problems with varchar/text

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