On Fri, 2006-07-28 at 03:37, Manlio Perillo wrote: > Hi. > > There can be performancs problems in having primary keys of type TEXT? > What about having a primary key of 3 columns (all of type TEXT)?
The biggest problem with using text as a primary key or foreign key is that text types are locale dependent, so that you might get one behaviour on one server and another behaviour on another, depending on configuration of the locale and the locale support on that machine. For instance, if you have a locale that says that E and e are equivalent, and another locale that says they aren't... ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
