My 2 cents: ArcSDE 9.2 stores by default in Unicode. 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.
Workaround: 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" 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. Best, Oscar * ***************************************************************************************************************************** * *Oscar GOMEZ PRIETO* *Joint Research Centre European Commmission * *Institute for Environment and Sustainability Rural, Water and Ecosystem Resources Unit * *Building 26A Office nº132 TP 262 Via Enrico Fermi 2749 I-21027, ISPRA(VA) Italy Tel. **+39 - 03.32.78.38.24 E-mail: [EMAIL PROTECTED] <[EMAIL PROTECTED]>* Unit Web site: **http://agrienv.jrc.it/** *** *DISCLAIMER:** The views expressed are purely those of the writer and may not in any circumstances be regarded as stating an official position of the European Commission.* *P** ** **Please consider the environment before printing this e-mail*** On Thu, Sep 4, 2008 at 4:16 PM, Joshua Hevenor <[EMAIL PROTECTED]>wrote: > 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. > > Cheers, > > Josh Hevenor > > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
