PSQL Data Type: text vs. varchar(n)

Поиск
Список
Период
Сортировка
От kurt _
Тема PSQL Data Type: text vs. varchar(n)
Дата
Msg-id BAY104-F40CF00A633CE8B6C6A42FC88D10@phx.gbl
обсуждение исходный текст
Ответы Re: PSQL Data Type: text vs. varchar(n)  (Chris <dmagick@gmail.com>)
Re: PSQL Data Type: text vs. varchar(n)  (Kris Jurka <books@ejurka.com>)
Список pgsql-general
I am having a problem with Sun Java Studio Creator because the latest
version of the JDBC driver returns a field length of -1 for text fields.

My question:  Is a text field just a varchar(Integer.MAX_VALUE)?  If I want
to use the data binding part of the SJSC tool I will need to convert my text
fields to some standard SQL data type.  I understand that varchar just
stores the actual length of the field, and not the padded white space.
Would anyone recommend for or against creating a field of
varchar(Integer.MAX_VALUE)?  Will PostgreSQL choke on that?  If against, how
is text implemented and how can I represent a variable-length String in a
SQL standard format?

Thanks.

_________________________________________________________________
Don�t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


В списке pgsql-general по дате отправления:

Предыдущее
От: Kai Hessing
Дата:
Сообщение: Re: Converting a database from LATIN1 to UTF-8
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Performance Killer 'IN' ?