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

Reply via email to