diff options
| author | rowanbeentje <rowan@beent.je> | 2009-11-30 00:16:36 +0000 |
|---|---|---|
| committer | rowanbeentje <rowan@beent.je> | 2009-11-30 00:16:36 +0000 |
| commit | 90911e029a969588d62aa5a84a4bd297fff01edc (patch) | |
| tree | 6f500813e7af8c6b31073e51c0346a06b151b25e | |
| parent | 574b1bb846f58edb5ada13ea404baea265851ec7 (diff) | |
| download | sequelpro-90911e029a969588d62aa5a84a4bd297fff01edc.tar.gz sequelpro-90911e029a969588d62aa5a84a4bd297fff01edc.tar.bz2 sequelpro-90911e029a969588d62aa5a84a4bd297fff01edc.zip | |
- Fix copying SQL INSERTs for binary-type strings (regression somewhere since 0.9.6)
| -rw-r--r-- | Source/CMCopyTable.m | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/Source/CMCopyTable.m b/Source/CMCopyTable.m index 98556a8d..1848e2d9 100644 --- a/Source/CMCopyTable.m +++ b/Source/CMCopyTable.m @@ -212,7 +212,7 @@ int MENU_EDIT_COPY_AS_SQL = 2002; else [types addObject:[NSNumber numberWithInt:1]]; // string (fallback coevally) } - +NSLog([types description]); [result appendString:[NSString stringWithFormat:@"INSERT INTO %@ (%@)\nVALUES\n", [(selectedTable == nil)?@"<table>":selectedTable backtickQuotedString], [tbHeader componentsJoinedAndBacktickQuoted]]]; @@ -245,8 +245,13 @@ int MENU_EDIT_COPY_AS_SQL = 2002; [value appendString:[NSString stringWithFormat:@"%@, ", [rowData description]]]; break; case 1: // string - [value appendString:[NSString stringWithFormat:@"'%@', ", - [mySQLConnection prepareString:[rowData description]]]]; + if ([rowData isKindOfClass:[NSData class]]) { + [value appendString:[NSString stringWithFormat:@"X'%@', ", + [mySQLConnection prepareBinaryData:rowData]]]; + } else { + [value appendString:[NSString stringWithFormat:@"'%@', ", + [mySQLConnection prepareString:[rowData description]]]]; + } break; case 2: // blob if (![[self delegate] isKindOfClass:[CustomQuery class]] && [rowData isSPNotLoaded]) { |