Thread: Text Datatype

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    69
    Rep Power
    11

    Text Datatype


    I would like to know what is the maximum amount of characters in the TEXT datafield and are their any restrictions wrt the type of characters that are put into this field. I am trying to import data into a text field in Postgres which should atleast accomodate a total of 1000 characters.

    Tx in advance
    Manisha
  2. #2
  3. Me likey breadsticks...
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2003
    Location
    Los Angeles
    Posts
    1,189
    Rep Power
    18
    http://www.postgresql.org/docs/curre...character.html

    Unlimited length according to the docs. Although you can specify a max limit if you're sure that it won't go over 1000 characters.

    -b
    PostgreSQL, it's what's for dinner...

IMN logo majestic logo threadwatch logo seochat tools logo