Thread: datatypes: text vs varchar

Hello,

    Can anybody tell us - how much 'text' datatype harder for
    database vs 'varchar(xx)' datatype? How much queries, which
    use this types differ in performance? We use only 'text'
    fields. Is 'varchar' (without specifying width) synonym
    for 'text', or not?    Thanks.


    ---
      best regards,
    Ruslan A Dautkhanov   rusland@scn.ru

On Sun, 2002-12-08 at 08:28, Ruslan A Dautkhanov wrote:
>     Hello,
>
>     Can anybody tell us - how much 'text' datatype harder for
>     database vs 'varchar(xx)' datatype?

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/datatype-character.html

>From that page: "Tip:  There are no performance differences between
these three types, apart from the increased storage size when using the
blank-padded type."

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC