Author Topic: MySQL: No DEFAULT on TEXT/BLOB in Strict Mode  (Read 555 times)

talentraspel

  • Wayfarer
  • *
  • Posts: 7
    • View Profile
MySQL: No DEFAULT on TEXT/BLOB in Strict Mode
« on: December 31, 2006, 03:36:42 am »
Hi.

Some scripts in src\server\database\mysql have default values on blob or text fields that are not allowed when running mysql in strict mode wich is default. I suggest removing the default values for the blob and text fields in the following files:

petition.sql
progess_events.sql
quest_skript.sql
tips.sql

Info from the Net:
"MySQL 5.x BLOB/TEXT columns cannot have default values any longer.
As of MysQL 5.0.2, when in strict mode adding a default value to BLOB/TEXT columns will cause an error, otherwise it will return a warning."

An other option would be to include the information for setting the correct mode in the documenation.


Regards,
Kai.