[UMN_MAPSERVER-USERS] MySQL OGR connection

[antti siukola]

Hi!

I have an ovf file that uses the gdal mysql driver to load data from
database but somehow when the data is returned two of three string
columns are in binary form. So the string is now unreadable. What
could cause this?

Here's the ovf file that I use:

<OGRVRTDataSource>

   <OGRVRTLayer name="name">
       
<SrcDataSource>MYSQL:bdname,user=user,password=password,host=localhost,port=3306</SrcDataSource>
        <SrcSQL>SQL clause </SrcSQL>
        <GeometryField encoding="WKT" field="geom"/>
    </OGRVRTLayer>

</OGRVRTDataSource>

Thanks in advance!

Antti S