The maximum size hard drive OS X can support is in the terabytes, I believe. You can't buy a hard drive today that would be too large for OS X.
Hardware, on the other hand, has limitations. For example, any computer without LBA (large block addressing?) cannot use hard drives larger than 137GB. Well, they CAN use them, but only 137GB would be available to use (that's even if you create multiple partitions -- only 137GB is available TOTAL). My computer doesn't support 48-bit LBA. Most computers released since 2000 or 2001 support 48-bit LBA. This also only applies to the internal IDE chain -- if I were to get a 250GB drive and slap it in a firewire enclosure, I could use all 250GB -- as long as the enclosure supports 48-bit LBA.
I would recommend getting a FireWire enclosure for the drive. Just about any generic one will work, but for guaranteed compatibility, visit here:
http://eshop.macsales.com/Catalog_Page.cfm?Parent=1087&Title=&Template=1
Great company. Everything I've purchased from them has worked 100%.