0
I have this error adding tables to my database. Does anyone know how to help me in this situation? For the dice are already as Barracuda.
The fields I’m adding are Type: Text, Varchar(20), Longblob.
1 answer
3
Based on Row size Too large error in mysql create table query, in the OS, translation text:
The total size of all table fields is more than the limit, 65535, which is why you are getting this error. You should use text type instead of varchar for long strings. Replace all varchar (8000) with text, and it should work. Or, better yet, use appropriate data types instead of the "very large" ones. You really don’t need 8000 characters to store currency, it’s not?
Try to follow this guidance and give us feedback, later on, I myself never went through it, but, always have the first time.
-
and I have to change everything I’ve varchar to text..
-
Good question @Chrisadler, I would do the following would create a test table and would change to see what happens, it is the only way you really get your doubt, and with that post here what happened!
-
1
Create a table too with lots of data? But instead of varchar being correct text?
-
Yeah, @Chrisadler, as a test ... then you watch the behavior
-
Ready tested a table to part replace all varchar by text. Until see worked.
-
It worked @Chrisadler ???
-
1
Yes, it did. I think I was making a mistake because of the Bible
Browser other questions tagged php mysql
You are not signed in. Login or sign up in order to post.
From the way you spoke your table really has MANY fields. After changing the types of the columns, if the error persists, maybe it is worth to separate in more than one table your data. If there are so many fields, probably you will not make a query that involves all this data even, can even separate leaving together the fields that are searched together.
– Pedro Lorentz