aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPSQLExporter.m
diff options
context:
space:
mode:
Diffstat (limited to 'Source/SPSQLExporter.m')
-rw-r--r--Source/SPSQLExporter.m6
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]];