On Tue, Jun 16, 2009 at 12:24 AM, Konstantin Izmailov<pgfizm@gmail.com> wrote:
> Hello,
> I've found following description: "If character varying is used without
> length specifier, the type accepts strings of any size. The latter is a
> PostgreSQL extension."
>
> Does this mean that "character varying without length" is equivalent to
> "text" type. Are there any differences?
>
> I noticed that ODBC driver processes the type differently from "text".
>
> Please help!
> Konstantin
This question would be more appropriate for pgsql-general or maybe
pgsql-odbc, since it is not a question about the development of
PostgreSQL.
character varying and text are different types, but there's no real
difference between them. I can't speak to what the ODBC driver does.
...Robert