StrongAuth, Inc. Forums

[mayo]

Just in case anyone else has the problem, I wanted to post an error I came across that I wasted some time on and had a simple reason/fix.

Upon running in MySQL the command "source create.txt" I would get 5 or 6 errors that read

"ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to chang
some columns to TEXT or BLOBs"

I'm installing a test strongkey environment on windows with a previous installation of MySQL.  Contrary to the instructions I didn't use the my.cnf config file given because I didn't know how at first, but I used the MySQL admin tools to configure the mysql windows service to match the config.


FIX
I lack DB knowledge and eventually found the DB Characterset being used caused the error. For some reason mine was set to UTF-8. Make sure the symkey database is using latin1 as its characterset.  Type "status" at mysql command line to see what the DB characterset is.  In MySQL admin tools, you can find the characterset setting under Startup Variables and the Advanced tab.  There's a way to set it via MySQL command line.  You should be able to find all other information via Google pretty easily.

[shuaige]

Not to necro-post, but I found this posting on Google when searching for the exact same MySQL problem.
And it worked! I changed my database's CHARSET to latin1 from utf8, and my CREATE TABLE statement went through without that stupid error.

Just for anyone running into the same problem and randomly coming across this, this solution is valid.

Thanks!

[mayo]

glad i could contribute!

[noxym.com]

glad i could contribute!

i think this is difrent then other query of php