Bug #66981 Canonical CHAR/VARCHAR representations for object values
Submitted: 27 Sep 2012 5:03 Modified: 12 Feb 2013 18:33
Reporter: Gopi Reddy Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[27 Sep 2012 5:03] Gopi Reddy 
Description:
For object types like the GEOMETRY type, accept and return a text value.  This has two benefits:

1) It will restore the CHAR/VARCHAR type as a canonical type,
2) It will simplify database programming using ORMs like Propel.

Without this feature, try inserting a geometry object (say a polygon) into the database through an ORM like Propel. It's possible but is unnecessarily cumbersome.

JSON is an ideal candidate for the canonical text format.

How to repeat:
This is a feature request.

Suggested fix:
For every object type, define a JSON structure and interpret the string value as JSON.
[3 Feb 2013 17:34] MySQL Verification Team 
Is this really a duplicate of bug #55308 ?