Re: Because you guys/gals/girls/women/insert pc term here are a smart lot

Ross McKay wrote: > First, start here: > > http://dev.mysql.com/doc/refman/5.1/en/string-types.html > > Stuart wrote: > > >>> varchar: only the space required for the content of the field is >>> allocated per row but these fields are limited to 255 chars (IIRC) in >>> length. >>> > > In MySQL, varchar can hold "up to" 65,535 characters, but the actual > maximum size is limited by the maximum row length (65,535 bytes) and the > character set (e.g. utf8 uses between one and three bytes per > character). > > Maybe you're thinking of char, which is limited to 255 characters. > You're referencing the 5.1 manual. In the 5.0 manual it says that VARCHAR was extended to 65535 in 5.0.3, so you're statement is not entirely correct, nor was Stuart's. That's why I linked him to the 5.0 manual page on data types. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com