MySQL said ERROR#1118 - Too big row size. Change some fields to BLOBS. What does this mean?

Question

#1118 - Too big row size. The maximum row size, not counting BLOBs, is 65535 (can be lower for some table types). You have to change some fields to BLOBs

How do i change some of my fields to BLOBs and what exactly changes to the fields if i do that? I dont want to ruin my database.

Answer 1

BLOB columns are treated as binary strings (byte strings). TEXT columns are treated as non-binary strings (character strings)

Character strings have the limits you show where binay strings do not.

Here is the manual page for blobs.
http://dev.mysql.com/doc/refman/5.0/en/blob.html
It really should not affect you as long as the field is not indexed or have other comparision type entry. If you are storing that much data in a row there are probably some fields that can be set to a blob type.

Answer 2

assuming you have 1 column for each field type like this :
Char(100) = 100 bytes
Datetime = 8 bytes
Varchar(500) = 500 + 1 bytes
then size of MySql row is : 100 + 8 + 501.
if the size of the row more than 65534, MySql will return error 1118.
Text and blob columns are implemented differently, each record in a text or blob column is made up of two separate parts. one part in original table, and the other part in hidden table. so by replacing some varchar column to blob, you saved some space for another column.
http://dev.mysql.com/doc/refman/4.1/en/storage-requirements.html

to change the field type :
ALTER TABLE something MODIFY fieldSomething BLOB;

Answer 3

There's no "set" schedule of when to change your baby's nappy. It's anytime it is wet or soiled. We went through SOOOOOO many diapers because my daughter was very well hydrated and had a great appetite. I don't think she ever sat in a soild diaper longer than 5 minutes before she was changed. In fact, she still doesn't and she's 14 months now. We're working on potty training and she's doing quite well. She lets us know when she has a wet diaper because she doesn't like it. Would you? LOL. New borns are especially important to change often. Their skin is so sensitive and you don't want them getting an infection or irratation of the skin. Bottom line, check the nappy at least every 30 minutes to make sure it's clean and dry. If not, change it. When you feed your baby at night, go ahead and change the nappy after the feeding. The size of the nappy doesn't affect how often you'll have to change it. You want to make sure it fits correctly so it won't leak. Besides, the smaller the nappy, the more that come in the package so don't rush to go into a bigger size until it's time to. It would just be a waste of money. I still can't get over your doctor advocating that mothers don't always change them when pooped-in. Is he condoning this behavior? He should be shot... not literally, of course.

Answer 4

La variedad de tabletas que les puedes encontrar en amazon son de la mejor calidad, como me gusta mucho mi tableta que he comprado en amazon he decidió comprar una Tableta y para mi hija, de esta forma dejando de jugar con la mía, le he comprado una Tableta muy practica para su edad, una tableta tanto educativa como divertida, lo mejor de esta tableta es que le gusta tanto su nueva tableta que ha olvidado completamente de la mía.