> > > Do you have any comments about this approach?
> > > What could possibly go very bad about relying on
> > > this usage of the COMMENT?
> > Yes, in different storage engines, different stuff is returned.
> > For example, in InnoDB, what you get returned from
> > SHOW FULL COLUMNS is not what you stored in the
> > "Comment" part.
> I currently use MyISAM, but I just tried a simple
> create(InnoDB)/show full columns from/ and
> it actually does return the JSON strings I put in.
Try it on columns with a foreign key constraint.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!