diff options
| -rw-r--r-- | Source/SPCSVExporter.m | 5 | ||||
| -rw-r--r-- | Source/SPCopyTable.m | 14 | ||||
| -rw-r--r-- | Source/SPSQLExporter.m | 6 | ||||
| -rw-r--r-- | Source/SPXMLExporter.m | 3 |
4 files changed, 26 insertions, 2 deletions
diff --git a/Source/SPCSVExporter.m b/Source/SPCSVExporter.m index deae305b..132d181b 100644 --- a/Source/SPCSVExporter.m +++ b/Source/SPCSVExporter.m @@ -285,7 +285,10 @@ [csvCellString setString:[NSString stringWithString:dataConversionString]]; [dataConversionString release]; - } + } + else if ([csvCell isKindOfClass:[MCPGeometryData class]]) { + [csvCellString setString:[csvCell wktString]]; + } else { [csvCellString setString:[csvCell description]]; } diff --git a/Source/SPCopyTable.m b/Source/SPCopyTable.m index 736052dc..886fe1e8 100644 --- a/Source/SPCopyTable.m +++ b/Source/SPCopyTable.m @@ -301,6 +301,9 @@ NSInteger MENU_EDIT_COPY_AS_SQL = 2003; [result appendFormat:@"%@\t", displayString]; [displayString release]; } + } + else if ([cellData isKindOfClass:[MCPGeometryData class]]) { + [result appendFormat:@"%@\t", [cellData wktString]]; } else [result appendFormat:@"%@\t", [cellData description]]; } else { @@ -374,6 +377,10 @@ NSInteger MENU_EDIT_COPY_AS_SQL = 2003; else if ([t isEqualToString:@"blobdata"] || [t isEqualToString:@"textdata"]) columnTypes[c] = 2; + // GEOMETRY data + else if ([t isEqualToString:@"geometry"]) + columnTypes[c] = 3; + // Default to strings else columnTypes[c] = 1; @@ -440,6 +447,10 @@ NSInteger MENU_EDIT_COPY_AS_SQL = 2003; } break; + // GEOMETRY + case 3: + [value appendFormat:@"X'%@', ", [mySQLConnection prepareBinaryData:[cellData data]]]; + break; // Unhandled cases - abort default: NSBeep(); @@ -540,6 +551,9 @@ NSInteger MENU_EDIT_COPY_AS_SQL = 2003; [result appendString:displayString]; [displayString release]; } + } + else if ([cellData isKindOfClass:[MCPGeometryData class]]) { + [result appendFormat:@"%@\t", [cellData wktString]]; } else [result appendFormat:@"%@\t", [cellData description]]; } else { diff --git a/Source/SPSQLExporter.m b/Source/SPSQLExporter.m index becccab2..64251456 100644 --- a/Source/SPSQLExporter.m +++ b/Source/SPSQLExporter.m @@ -385,7 +385,7 @@ else if ([object isKindOfClass:[NSData class]]) { if ([self sqlOutputEncodeBLOBasHex]) { - [sqlString appendFormat:@"X'%@", [connection prepareBinaryData:object]]; + [sqlString appendFormat:@"X'%@'", [connection prepareBinaryData:object]]; } else { [sqlString appendString:@"'"]; @@ -403,6 +403,10 @@ [sqlString appendString:@"'"]; } + // GEOMETRY data types directly as hex data + else if ([object isKindOfClass:[MCPGeometryData class]]) { + [sqlString appendFormat:@"X'%@'", [connection prepareBinaryData:[object data]]]; + } else { [cellValue setString:[object description]]; diff --git a/Source/SPXMLExporter.m b/Source/SPXMLExporter.m index 83497ec4..4d776f55 100644 --- a/Source/SPXMLExporter.m +++ b/Source/SPXMLExporter.m @@ -195,6 +195,9 @@ else if ([data isKindOfClass:[NSNull class]]) { [xmlItem setString:[self xmlNULLString]]; } + else if ([data isKindOfClass:[MCPGeometryData class]]) { + [xmlItem setString:[data wktString]]; + } else { [xmlItem setString:[data description]]; } |