Hello.
Have a look here: http://dev.mysql.com/doc/refman/5.0/en/data-size.html You can freely download a sample character about data types from perfect book (MySQL 3-d edition): http://www.samspublishing.com/articles/article.asp?p=374690 You said that you're going to TEXT fields, may be you should be aware of this quote from: http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-limitations.html " Text indexes are not supported." Cory Robin wrote: > I'm runnung MySQL-Cluster 5.0.15 on Linux. > > I have to do some re-design of a website database that has quickly > outgrown itself. I'm trying to migrate to MySQL Cluster 5.0.15. > Mostly I've used VarChar fieldtypes in the past, but I want to make sure > I'm using the best fieldtype for alphanumeric indexed fields. > > Some of the data I'm storing will be fixed in length and some will be > variable in length. I've thought of just going to TINYTEXT and TEXT > fields. > I'm really wanting good memory utilization and speed. Perhaps there's a > way to do this and get a reasonable combo of both. > > Are there any tutorials for setting up MySQL Field Types (for a > somewhat-newbie to advanced database design) on the net? > > Cory @ SkyVantage > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
