Peter, Thursday, June 06, 2002, 12:29:53 PM, you wrote: PE> I store firstname, lastname, telephone etc in a table
PE> Is there any drawback with using tinytext? PE> As I can see when I store strings that differ in length, the PE> best would be to use tinytext, or? PE> http://www.mysql.com/doc/n/o/node_369.html PE> In terms of fulltextsearch/index etc. PE> What is the difference if I use a tinytext as column type PE> instead of a fixed char length? CHAR column type has fixed length, use CHAR() if you know in advance how many characters are going to be in that field. CHAR will be slightly faster then tinytext. Don't forget that if the table contains variable-length fields (varchar, text, blob) then all char columns longer than 3 characters are silently changed to VARCHAR columns: http://www.mysql.com/doc/S/i/Silent_column_changes.html PE> Best regards PE> /Peter -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
