support strange mysql quoting

qgis · Jan 30, 2012 · 93266ac · 93266ac
1 parent cbef41c
commit 93266ac
Showing 1 changed file with 13 additions and 4 deletions.
diff --git a/src/providers/ogr/qgsogrprovider.cpp b/src/providers/ogr/qgsogrprovider.cpp
@@ -2241,10 +2241,19 @@ QVariant QgsOgrProvider::maximumValue( int index )
 
 QString QgsOgrProvider::quotedIdentifier( QString field )
 {
-  field.replace( '\\', "\\\\" );
-  field.replace( '"', "\\\"" );
-  field.replace( "'", "\\'" );
-  return field.prepend( "\"" ).append( "\"" );
+  if ( ogrDriverName == "MySQL" )
+  {
+    field.replace( '\\', "\\\\" );
+    field.replace( "`", "``" );
+    return field.prepend( "`" ).append( "`" );
+  }
+  else
+  {
+    field.replace( '\\', "\\\\" );
+    field.replace( '"', "\\\"" );
+    field.replace( "'", "\\'" );
+    return field.prepend( "\"" ).append( "\"" );
+  }
 }
 
 bool QgsOgrProvider::syncToDisc()