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 tr
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 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
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 broadca
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/
"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 choo
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
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
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 tool
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
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
12 matches
Mail list logo