[mapserver-users] MySQL Blob vs Text issue with mapserver

[john]

I am connected to mysql through a ms layer but am receiving a text layer in
hex numbers as if it were a blob.  SiteName and cultaffil are TEXT layers,
but are interpreted as blobs as far as I can tell.  Is there either a fix
for this or a workaround?

 

Thanks

 

 

LAYER

    NAME "Sites"

    STATUS OFF

    GROUP "Sites"

    TYPE POINT

    TOLERANCE 8

    TOLERANCEUNITS pixels

    CONNECTIONTYPE OGR  

    CONNECTION "MYSQL:test,user=username,password=pass"

    DATA "Select * from site_point"

TEMPLATE "void"

  METADATA 

    "DESCRIPTION" "Sites"

    "RESULT_FIELDS" "SiteNumber,SiteName,cultaffil"

    "RESULT_HEADERS" "Site Number,Site Name,Cultural Affiliation"

    "RESULT_HYPERLINK" "SiteNumber"

    "LAYER_ENCODING" "UTF-8"

    "ows_title"      "Sites"

  END  # Metadata

END

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080815/aef60b50/attachment.htm>