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)
Re: PSQL Data Type: text vs. varchar(n) |
Список | 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 по дате отправления: