Index: src/insert.c
==================================================================
--- src/insert.c
+++ src/insert.c
@@ -10,11 +10,11 @@
 **
 *************************************************************************
 ** This file contains C code routines that are called by the parser
 ** to handle INSERT statements in SQLite.
 **
-** $Id: insert.c,v 1.263 2009/05/01 15:17:48 drh Exp $
+** $Id: insert.c,v 1.264 2009/05/02 00:28:20 drh Exp $
 */
 #include "sqliteInt.h"
 
 /*
 ** Generate code that will open a table for reading.
@@ -1487,11 +1487,11 @@
       return 0;   /* Different columns indexed */
     }
     if( pSrc->aSortOrder[i]!=pDest->aSortOrder[i] ){
       return 0;   /* Different sort orders */
     }
-    if( pSrc->azColl[i]!=pDest->azColl[i] ){
+    if( !xferCompatibleCollation(pSrc->azColl[i],pDest->azColl[i]) ){
       return 0;   /* Different collating sequences */
     }
   }
 
   /* If no test above fails then the indices must be compatible */