diff options
Diffstat (limited to 'Source/SPSQLExporter.m')
-rw-r--r-- | Source/SPSQLExporter.m | 6 |
1 files changed, 5 insertions, 1 deletions
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]]; |