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