Reply to Re: Char or varchar for a primary key?

Your name:

Reply:


Posted by D. on 05/28/07 13:29

>
> Because of some other considerations (the 'first' VARCHAR column will
> cost an additional 5 bytes per row), when in doubt, I would choose CHAR
> over VARCHAR. In your case, I would choose VARCHAR(10) if the average
> length is 6 or smaller. Otherwise I would choose CHAR(10).
>

Usually the key is fully filled, so I think I'll try to change varchar to
char.

Davide.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация