[mapserver-users] OGR Virtual Format and character encoding

[Frank Warmerdam]

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