Hello again Armin, I think I know what going on. Quote MS Support:
"Some applications (especially those that are Web based) must deal with Unicode data that is encoded with the UTF-8 encoding method. SQL Server 7.0 and SQL Server 2000 use a different Unicode encoding (UCS-2) and do not recognize UTF-8 as valid character data. This article discusses some options for dealing with this situation." It goes on... http://support.microsoft.com/kb/232580 The search.xml works for numeric fields. And yes, as a shape layer. My thinking is that I need to use the SQL server as a backend server that sends and receives Unicode data that is encoded as UTF-8. I thought I could get some feed-back from you before I ask our SQL Server Administrator to fix this. George Sorry, I cannot tell you anything about Mapserver and SDE layers. I don't know if they use query syntax as Postgis and Oracle or as shapefile layers. I would guess that 'normal' search without any special settings (like 'options' or 'suggest') should work without problem. Otherwise you will need to try testing things on your own, including modifying the code responsible for preparing and executing the query (mainly search.php and query.php). I do not have access to SDE and I'm not planning to test this. If you have any news and found out how and what to change I can incorporate this into the code. armin On 11/06/2009 19:46, McCown, George wrote: > As you know, mapserver has no support for UNICODE columns for a sde > database. > > Turning this off satisfies the labeling however special coding in the > search.xml is needed. > > Since pmapper uses UTF-8 encoding my question is how would I modify the > code to > > recognize a SQL sde database? > > > > Thanks! > > > > > > > This email and any files transmitted with it are intended solely for the use of the individual and/or entity to whom it is addressed. Unless noted otherwise above, any distribution or copying of this email is strictly prohibited. This email IS NOT a binding agreement on behalf of JJG. If you have received this message in error, please immediately notify the sender and delete this message from your computer. > Jordan, Jones and Goulding, Inc., 6801 Governors Lake Pkwy, Norcross, Ga. 30071 www.jjg.com > > ------------------------------------------------------------------------ ------ > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensing option that enables unlimited > royalty-free distribution of the report engine for externally facing > server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > This email and any files transmitted with it are intended solely for the use of the individual and/or entity to whom it is addressed. Unless noted otherwise above, any distribution or copying of this email is strictly prohibited. This email IS NOT a binding agreement on behalf of JJG. If you have received this message in error, please immediately notify the sender and delete this message from your computer. Jordan, Jones and Goulding, Inc., 6801 Governors Lake Pkwy, Norcross, Ga. 30071 www.jjg.com ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
