db2 is limited to 255.
On Fri, 16 Feb 2001, Eric Frazier wrote:
> Date: Fri, 16 Feb 2001 14:13:00 -0800
> From: Eric Frazier <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: varchar and sql92
>
> Hi,
>
> I am writing a program to do queries on a lot of different databases. I have
> run into something with varchar I didn't expect.
>
> With mySQL varchar is limited to 255 with postgress it is unlimited it
> seems. I only know because it seems to work, not because their stupid
> documentation told me, that you can have any length varchar. For instance I
> have a varchar 4000 in a postgress database.
>
> My question is, how standard is mySQL being by limiting varchar to 255 ? I
> will have to make some provision for this because I want my queries to work
> with postgress as well, but I wondered too if I should look into other
> issues like this with lengths of fields?
>
> Thanks,
>
> Eric
>
>
> Frazier Consulting
> http://www.kwinternet.com/eric
> (250) 655 - 9513
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
