We had this problem too. When we load data into SDE we now use a UTF8 keyword so that the string columns use varchar type instead of nvarchar.<br><br>Cheers,<br>Liz Eidsness<br><br><div class="gmail_quote">On Tue, Dec 9, 2008 at 4:33 PM, Bistrais, Bob <span dir="ltr"><<a href="mailto:Bob.Bistrais@maine.gov">Bob.Bistrais@maine.gov</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Thanks Howard. Has anyone ever been able to find a workaround (besides<br>
using shapefiles)?<br>
<div><div></div><div class="Wj3C7c"><br>
-----Original Message-----<br>
From: Howard Butler [mailto:<a href="mailto:hobu.inc@gmail.com">hobu.inc@gmail.com</a>]<br>
Sent: Tuesday, December 09, 2008 4:31 PM<br>
To: Bistrais, Bob<br>
Cc: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
Subject: Re: [mapserver-users] Labels with SDE data<br>
<br>
<br>
On Dec 9, 2008, at 3:09 PM, Bistrais, Bob wrote:<br>
<br>
> I am using ESRI SDE layers in a Map file. On some polygon layers, a<br>
> text label appears as a strange symbol, such as horizontal lines or a<br>
> square. If I convert the same layer to shapefile and use it as a<br>
> source, the polygon labels look correct.<br>
><br>
> How can I correct this so the labels look correct using SDE layers?<br>
><br>
<br>
The column you are labeling with likely has unicode characters in it<br>
and there is a bug in the MapServer SDE code. See this thread for<br>
some more detail.<br>
<a href="http://lists.osgeo.org/pipermail/mapserver-users/2008-November/058674.html" target="_blank">http://lists.osgeo.org/pipermail/mapserver-users/2008-November/058674.ht<br>
ml</a><br>
<br>
Howard<br>
<br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div></div></blockquote></div><br>