Description Markus Surudo 2012-04-12 05:48:26 EDT

Build Identifier: 

It is possible that two different UUIDs are created which only differ in lower/upper case letters. If we try to save this element in the database we get a duplicate key exception. 

using 

LONGTEXT CHARACTER SET 'latin1' COLLATE 'latin1_bin'

on the ID column makes it case sensitive but no idea how/if the foreign key resolution of UUIDs will work.

This fix is possibly mySQL specific and will not work on other DBs due to syntax.

Reproducible: Always

Steps to Reproduce:
1. Import a big resource (many objects) into CDO
2. Try to save the resource
3. SQL error occurs