[mapserver-users] OGR Virtual Format and character encoding

[Chris Jackson]

Frank

I am using <SrcDataSource>ODBC:..... in the OVF file.  I am parsing the
file using OGRinfo via commandline and the characters are looking odd
straight away.  Hadn't thought about using the spatial add-on for 2005, can
that be called directly from the mapfile instead?  I usually just use
shapefiles (performance surprising good), but have need of a SQL table of
point data (all over Europe - hence the character issues) updated via a
web-form to be called via MapServer and another application.  Any pointers
appreciated!

Cheers
Chris

On 31 August 2012 21:16, Frank Warmerdam <warmerdam at pobox.com> wrote:

> Chris,
>
> I'm a bit unclear if the problem is happening in the MS SQL driver, or in
> the
> VRT driver.  If you use OGR directly against the MS SQL data are things
> messed up?  Are you using ODBC or the actual MSSQLSpatial driver?
>
> Best regards,
> Frank
>
> On Fri, Aug 31, 2012 at 1:07 PM, Chris Jackson <webturtles at gmail.com>
> wrote:
> > All
> >
> > One thought I did have, if the characters where html encoded in the SQL
> > table (e.g. ü as ü) is there anyway to get MapServer to render them
> > correctly again in a label?  I guess OGR can only deal with UTF-8 encoded
> > characters (I am using nvarchar fields, but in an ISO collation in SQL
> 2005
> > - not v.UTF-8 friendly I think!)
> >
> > Thanks
> > Chris
> >
> >
> > On 30 August 2012 15:46, Chris Jackson <webturtles at gmail.com> wrote:
> >>
> >> Hi all
> >>
> >> I have OGR Virtual Format layer in my map file and the underlying .OVF
> is
> >> calling a flat MS SQL table of point data.  The layer displays fine,
> but I
> >> am having issues with umlauts etc for one of the attribute fields.
>  When I
> >> run the ogrinfo command on the layer, it has already messed up the
> encoding.
> >> In SQL it looks and queries fine.  Any pointers on how you can maintain
> the
> >> encoding?
> >>
> >> Many thanks
> >> Chris
> >
> >
> >
> > _______________________________________________
> > mapserver-users mailing list
> > mapserver-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
> >
>
>
>
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Software Developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120831/f909b740/attachment.html>