when i try to insert the string " http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=2012774576";, it returns "error : Duplicate entry ' http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=' for key 3"
when i check the table and do a search for the string, there is no match...it seems that they index is not using the full field to index and finding a duplicate index key even though there is not a dupliate field - is there a 70 character limit on varchar unique indexes or something weird?. this is an InnoDB table with 2 unique keys and a few other keys...i'm assuming key 3 deals with this data since it is one of the unique keys and it shows this data in the error...but how do i confirm which is 'key 3'? i've been searching around and can't find any mention known issues around this. any help/suggestions would be greatly appreciated. thanks, jerad
