gistfile1.txt

                                                                     
                                                                     
                                                                     
                                             
sed 's/latin1/utf8/' aquent_195backup.sql >aquent_195backup_utf8.sql

alter database aquent_dotcms charset=utf8;



delete from permission_reference where length(asset_id)>36;
delete from clickstream_request where length(associated_identifier)>36;

delete from tree where child in ('b0175b42-5281-4102-9fe8-88aac2f43318','751872','10d13a35-8905-4fe5-9f2e-d48da6302d20','edf9c6cb-1e9f-46b3-b389-776792557171');
delete from inode where identifier in ('c47f36c0-8c93-408e-a2b1-cf0c340bc159','751873','2d1af7da-5801-4c2d-aeae-33a6c60c39ff','cdf3c1dd-a374-4563-8999-49dd6a835b07');