On 4 Apr 2006 04:15:06 GMT, Patrick TJ McPhee [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
Jim Nasby [EMAIL PROTECTED] wrote:
% Not sure if it's still true, but DB2 used to limit varchar to 255. I
% don't think anyone limits it lower than that.
Sybase: 254. Silently truncates.
Patrick TJ McPhee wrote:
In article [EMAIL PROTECTED],
Jim Nasby [EMAIL PROTECTED] wrote:
% Not sure if it's still true, but DB2 used to limit varchar to 255. I
% don't think anyone limits it lower than that.
Sybase: 254. Silently truncates.
IIRC, Oracle is 4096.
Jeff
In article [EMAIL PROTECTED],
Jim Nasby [EMAIL PROTECTED] wrote:
% Not sure if it's still true, but DB2 used to limit varchar to 255. I
% don't think anyone limits it lower than that.
Sybase: 254. Silently truncates.
--
Patrick TJ McPhee
North York Canada
[EMAIL PROTECTED]
On Thu, 30 Mar 2006, kurt _ wrote:
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.
You should try the latest development driver, 8.2dev-501.
Kris Jurka
---(end of
On Mar 31, 2006, at 12:51 AM, Tom Lane wrote:
Well, if you are looking for the lowest-common-denominator textual
column datatype, then varchar(255) is probably it ... I think even
Bill
Gates would feel ashamed to sell a database that could not handle
that.
But my reading of the OP's question
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
kurt _ wrote:
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
Chris wrote:
kurt _ wrote:
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
Chris [EMAIL PROTECTED] writes:
kurt _ wrote:
My question: Is a text field just a varchar(Integer.MAX_VALUE)?
varchar has a max of 255 characters,
You must be using some other database ;-)
The current Postgres code has a physical limit of 1G bytes for any
column value (and in practice
On Thursday 30 March 2006 21:27, Tom Lane wrote:
Chris [EMAIL PROTECTED] writes:
kurt _ wrote:
My question: Is a text field just a varchar(Integer.MAX_VALUE)?
varchar has a max of 255 characters,
You must be using some other database ;-)
The current Postgres code has a physical limit
Uwe C. Schroeder [EMAIL PROTECTED] writes:
On Thursday 30 March 2006 21:27, Tom Lane wrote:
My own take on this is that you should say what you mean. If you do
not have a clear application-oriented reason for specifying a particular
limit N in varchar(N), you have no business choosing a
Tom Lane wrote:
Chris [EMAIL PROTECTED] writes:
kurt _ wrote:
My question: Is a text field just a varchar(Integer.MAX_VALUE)?
varchar has a max of 255 characters,
You must be using some other database ;-)
Oops! Sorry :)
--
Postgresql php tutorials
http://www.designmagick.com/
12 matches
Mail list logo