Horton
Menu

Thread

  1. bpchar type

    Patrick Dunford <a47xxy@hotmail.com> — 2001-04-16T05:17:55Z

    I have some tables that I copied to a Postgres server from MS Access. The 
original tables were Paradox.

In fields that were originally Paradox Logical type, MS Access shows in the 
ODBC linked Postgres tables that the datatype of these fields is Text with a 
length of 1 character (Text being the MS Access type representation of what 
is on the server, not the server's datatype).

Zeos Database Explorer shows the type of these fields to be "bpchar", is 
this a Postgres data type?

-- 
=======================================================================
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/

   But Christ has indeed been raised from the dead, the firstfruits
of those who have fallen asleep.
    -- 1 Corinthians 15:20
http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010415
=======================================================================
Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/

  2. Re: bpchar type

    Peter Eisentraut <peter_e@gmx.net> — 2001-04-16T14:39:50Z

    Patrick Dunford writes:

> Zeos Database Explorer shows the type of these fields to be "bpchar", is
> this a Postgres data type?

bpchar is the internal name for char().

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

  3. Re: bpchar type

    Patrick Dunford <a47xxy@hotmail.com> — 2001-04-17T06:07:11Z

    On Mon, 16 Apr 2001 17:45:07 +0000 (UTC) AD in 
comp.databases.postgresql.general, Peter Eisentraut said: 

>Patrick Dunford writes:
>
>> Zeos Database Explorer shows the type of these fields to be "bpchar", is
>> this a Postgres data type?
>
>bpchar is the internal name for char().

interesting the next time I uploaded it correctly converted them to bool

-- 
=======================================================================
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/

   Then the end will come, when he hands over the kingdom to God
the Father after he has destroyed all dominion, authority and
power.
    -- 1 Corinthians 15:24
http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010416
=======================================================================
Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/

  4. Re: bpchar type

    Will Trillich <will@serensoft.com> — 2001-04-17T16:01:41Z

    On Mon, Apr 16, 2001 at 04:39:50PM +0200, Peter Eisentraut wrote:
> Patrick Dunford writes:
> 
> > Zeos Database Explorer shows the type of these fields to be "bpchar", is
> > this a Postgres data type?
> 
> bpchar is the internal name for char().

short for "blank-padded character". as opposed to varchar, which
is either "null-padded char" or "variable-length char" but we
don't have to worry about which. then there's text... hmm!

-- 
don't visit this page. it's bad for you. take my expert word for it.
http://www.salon.com/people/col/pagl/2001/03/21/spring/index1.html

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!