diff options
| -rw-r--r-- | Source/SPTableStructure.m | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Source/SPTableStructure.m b/Source/SPTableStructure.m index 581011cf..e79152bd 100644 --- a/Source/SPTableStructure.m +++ b/Source/SPTableStructure.m @@ -796,7 +796,7 @@ } // ADD COLLATE - if([fieldEncoding length] && [[theRow objectForKey:@"collation"] integerValue] > 0) { + if([fieldEncoding length] && [[theRow objectForKey:@"collation"] integerValue] > 0 && ![[theRow objectForKey:@"binary"] integerValue]) { NSArray *theCollations = [databaseDataInstance getDatabaseCollationsForEncoding:fieldEncoding]; NSString *col = [[theCollations objectAtIndex:[[theRow objectForKey:@"collation"] integerValue]-1] objectForKey:@"COLLATION_NAME"]; [queryString appendFormat:@"\n COLLATE %@", col]; |