Hello

what is the best for a char field with less than 1000 characters?
a text field or a varchar(1000)

thanks

Search Discussions

  • Steinar H. Gunderson at Jan 9, 2006 at 11:49 am

    On Mon, Jan 09, 2006 at 11:58:19AM +0100, TNO wrote:
    what is the best for a char field with less than 1000 characters?
    a text field or a varchar(1000)
    They will be equivalent. text and varchar are the same type internally -- the
    only differences are that varchar can have a length (but does not need one),
    and that some casts are only defined for text.

    If there's really a natural thousand-character limit to the data in question,
    use varchar(1000); if not, use text or varchar, whatever you'd like.

    /* Steinar */
  • Bruce Momjian at Jan 9, 2006 at 11:50 pm
    See the FAQ.

    ---------------------------------------------------------------------------

    Steinar H. Gunderson wrote:
    On Mon, Jan 09, 2006 at 11:58:19AM +0100, TNO wrote:
    what is the best for a char field with less than 1000 characters?
    a text field or a varchar(1000)
    They will be equivalent. text and varchar are the same type internally -- the
    only differences are that varchar can have a length (but does not need one),
    and that some casts are only defined for text.

    If there's really a natural thousand-character limit to the data in question,
    use varchar(1000); if not, use text or varchar, whatever you'd like.

    /* Steinar */
    --
    Homepage: http://www.sesse.net/

    ---------------------------(end of broadcast)---------------------------
    TIP 5: don't forget to increase your free space map settings
    --
    Bruce Momjian | http://candle.pha.pa.us
    pgman@candle.pha.pa.us | (610) 359-1001
    + If your life is a hard drive, | 13 Roberts Road
    + Christ can be your backup. | Newtown Square, Pennsylvania 19073

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-performance @
categoriespostgresql
postedJan 9, '06 at 10:58a
activeJan 9, '06 at 11:50p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase