On Sep 15, 2009, at 6:42 PM, P Kishor wrote: > Could it be that those seemingly identical multiple rows actually have > trailing spaces or some other non-visible character? Check for their > length.
Here we go: > sqlite> SELECT clientName, entityName, length(entityName) FROM > MyDBState ORDER BY entityName; > com.apple.AddressBook|com.apple.contacts.CalendarURI|30 > com.apple.AddressBook|com.apple.contacts.Contact|26 > com.apple.AddressBook|com.apple.contacts.Date|23 > com.apple.AddressBook|com.apple.contacts.Email Address|32 > com.apple.AddressBook|com.apple.contacts.Group|24 > com.apple.AddressBook|com.apple.contacts.IM|21 > com.apple.AddressBook|com.apple.contacts.ImageTransformationInfo|42 > com.apple.AddressBook|com.apple.contacts.ImageTransformationInfo|42 > com.apple.AddressBook|com.apple.contacts.Phone Number|31 > com.apple.AddressBook|com.apple.contacts.Phone Number|31 > com.apple.AddressBook|com.apple.contacts.Related Name|31 > com.apple.AddressBook|com.apple.contacts.Related Name|31 > com.apple.AddressBook|com.apple.contacts.SmartGroup|29 > com.apple.AddressBook|com.apple.contacts.SmartGroup|29 > sqlite> -- Tito _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users