<div dir="ltr"><div class="gmail_quote"><br>
<div dir="ltr">
<div>My 2 cents: ArcSDE 9.2 stores by default in Unicode.</div>
<div> </div>
<div>I'm afraid you'll need to reload all the data again to ArcSDE, using a keyword that does not store the string data in unicode by default.</div>
<div> </div>
<div>Workaround:</div>
<div> </div>
<div>a) Create a new ArcSDE keyword (or modify a existing one) with sdedbtune -o export (and after -o import), to include the following entry: UNICODE_STRING "FALSE"</div>
<div> </div>
<div>b) Load the data using an ArcSDE Oracle Spatial (SDO) keyword, then use MapServer with Oracle Spatial, removing the "ANNO_CAD_DATA" with the query in the map file.</div>
<div> </div>
<div>Best,</div>
<div> </div>
<div>Oscar</div>
<div> </div>
<div>
<p style="MARGIN: 6pt 0in"><a name="11c2de0cf8f16a0b__MailAutoSig"><b><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial">*****************************************************************************************************************************</span></b><span></span></a></p>
<p style="MARGIN: 6pt 0in"><span><b><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial">Oscar GOMEZ PRIETO</span></b><span></span></span></p>
<p style="MARGIN: 6pt 0in"><span><b><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial">Joint Research Centre <br>European Commmission </span></b></span></p>
<p style="MARGIN: 6pt 0in"><span><b><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial">Institute for Environment and Sustainability<br>Rural, Water and Ecosystem Resources Unit </span></b></span><span><span lang="EN-GB"></span></span></p>
<p style="MARGIN: 6pt 0in"><span><b><span lang="IT" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial">Building 26A Office nš132 TP 262 <br>Via Enrico Fermi 2749<br>I-21027, ISPRA(VA) Italy<br><br>Tel. </span></b></span><span><b><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial">+39 - 03.32.78.38.24 <br>
E-mail: </span></b></span><span></span><a title="blocked::mailto:paolo.prosperi@jrc.it" href="mailto:oscar.gomez@jrc.it" target="_blank"><span><b><span lang="EN-GB" style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">oscar.gomez@jrc.it</span></b></span></a><span><b><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial"> <br>
Unit Web site: </span></b></span><span></span><a title="blocked::blocked::http://agrienv.jrc.it/
blocked::http://agrienv.jrc.it/"><span><b><span lang="EN-GB" style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"><span title="blocked::blocked::http://agrienv.jrc.it/
blocked::http://agrienv.jrc.it/">http://agrienv.jrc.it/</span></span></b></span><span></span></a><span><b><span lang="IT" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial"> </span></b></span><span><b><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: #666699; FONT-FAMILY: Arial"></span></b></span></p>
<p style="MARGIN: 0in 0in 0pt"><span><b><i><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: navy; FONT-FAMILY: Arial">DISCLAIMER:</span></i></b></span><span><i><span lang="EN-GB" style="FONT-SIZE: 8pt; COLOR: navy; FONT-FAMILY: Arial"> The views expressed are purely those of the writer and may not in any circumstances<br>
be regarded as stating an official position of the European Commission.</span></i><span></span></span></p>
<p style="MARGIN: 6pt 0in; LINE-HEIGHT: 150%"><span><span title="BLOCKED::http://agrienv.jrc.it/
http://agrienv.jrc.it/"><b><i><span lang="EN-GB" style="FONT-SIZE: 24pt; COLOR: green; LINE-HEIGHT: 150%; FONT-FAMILY: Webdings"><span title="BLOCKED::http://agrienv.jrc.it/">P</span></span></i></b></span><span><b><i><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: navy; LINE-HEIGHT: 150%; FONT-FAMILY: Arial"> </span></i></b></span><span><b><i><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: blue; LINE-HEIGHT: 150%; FONT-FAMILY: Arial"> </span></i></b></span><span><b><i><span lang="EN-GB" style="FONT-SIZE: 7.5pt; COLOR: green; LINE-HEIGHT: 150%; FONT-FAMILY: Arial">Please consider the environment before printing this e-mail</span></i></b></span><span></span><b><i><span lang="IT" style="FONT-SIZE: 8pt; COLOR: #666699; LINE-HEIGHT: 150%; FONT-FAMILY: Arial"></span></i></b></span></p>
<br><br></div>
<div class="gmail_quote">
<div>
<div></div>
<div class="Wj3C7c">On Thu, Sep 4, 2008 at 4:16 PM, Joshua Hevenor <span dir="ltr"><<a href="mailto:jhevenor@rogers.com" target="_blank">jhevenor@rogers.com</a>></span> wrote:<br></div></div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div></div>
<div class="Wj3C7c">
<div>
<div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<div>Are your labels coming out garbled or not drawing at all. There's some incompatability between using NVARCHAR and VARCHAR as your source data. If your labels are showing up but are unreadable this could be the problem. Let me know, and when I get back to my office I can provide you with more detail. </div>
<div> </div>
<div>Cheers,</div>
<div> </div>
<div>Josh Hevenor</div>
<div> </div></div></div><br></div></div>
<div class="Ih2E3d">_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">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>
<br></div></blockquote></div><br><br clear="all"></div></div><br></div>