mysql default client charset to utf-8

[wolgri]

if there isno way to change client charset in ogr so whay need to use default swedish collation here some ugly workaround to fix this

diff -Naur gdal-1.5.2.orig/ogr/ogrsf_frmts/mysql/ogrmysqldatasource.cpp gdal-1.5.2/ogr/ogrsf_frmts/mysql/ogrmysqldatasource.cpp
--- gdal-1.5.2.orig/ogr/ogrsf_frmts/mysql/ogrmysqldatasource.cpp    2007-01-18 04:22:39.000000000 +0200
+++ gdal-1.5.2/ogr/ogrsf_frmts/mysql/ogrmysqldatasource.cpp 2008-07-11 12:18:35.000000000 +0300
@@ -209,7 +209,7 @@

     unsigned int timeout = atoi(pszTimeoutLength);
     mysql_options(hConn, MYSQL_OPT_CONNECT_TIMEOUT, (char*)&timeout);
-
+    mysql_options(hConn, MYSQL_SET_CHARSET_NAME, "utf8");
     if( hConn == NULL )
     {
         CPLError( CE_Failure, CPLE_AppDefined,
~

[warmerdam]

Per RFC 23 things ought to operate in UTF-8 in trunk. It is less clear what is appropriate in 1.5, so rather than rock the boat I'm just going to apply this in trunk.

[warmerdam]

Change applied in trunk (r14887). I did not actually do any testing as it seems straight forward.