<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'><BR>
<BLOCKQUOTE>
Mike,<BR>
I hesitated to respond it looked like you had more luck with the sde provider than I did. You didn't get any responses so I thought I would let you know my experiences in case they did help.<BR>
I haven't been running mgos for a while now but when I did I was connecting to an sde 9.2 database. I was experiencing a problem with the utf-8 or unicode setting. Now in 9.2 all fields in sde are defaulted to unicode if you look and you no longer have a varchar32 field type but an nvachar field type, that is the new unicode. I had to use the dbtune file to change the keyword parameter to <FONT face="" size=2>UNICODE_STRING "FALSE". I would imagine that just by knowing this you could reform you sql statement to either convert or accept this format (that is if it actually has anything to do with your problem).</FONT><BR>
BTW even the numeric fields are unicode.<BR>
<FONT size=2> <BR>
</FONT>
<HR id=EC_stopSpelling>
<BR>
Date: Wed, 15 Aug 2007 13:16:51 -0400<BR>From: Michael.Micallef@ontario.ca<BR>To: mapguide-users@lists.osgeo.org<BR>Subject: [mapguide-users] SDE Error with Search command<BR><BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass EC_p.MsoNormal, .ExternalClass EC_li.MsoNormal, .ExternalClass EC_div.MsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman';}
.ExternalClass a:link, .ExternalClass EC_span.MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass EC_span.MsoHyperlinkFollowed
{color:#606420;text-decoration:underline;}
.ExternalClass EC_span.EmailStyle17
{font-family:Arial;color:windowtext;}
.ExternalClass EC_span.EmailStyle18
{font-family:Arial;color:navy;}
@page Section1
{size:612.0pt 792.0pt;}
.ExternalClass EC_div.Section1
{page:Section1;}
</STYLE>
<DIV class=EC_Section1>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am using the FDO for ArcSDE connection to get at sde layers. They are displaying fine and I can select and get info back from them </SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">But</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">When using the built in search function to go against the data I continually get a “Unterminated string” Error and the map fails.</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">IU take the custom search out and the map works.</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Very basic search filter</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">"ASSESSMENT" LIKE '$USER_VARIABLE'</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I can’t get it to search against sde layers – tried 2</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Shapefile layers work fine</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any help would be greatly appreciated!</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Mike</SPAN></FONT></P></DIV></BLOCKQUOTE><br /><hr />Get news, entertainment and everything you care about at Live.com. <a href='http://www.live.com/getstarted.aspx ' target='_new'>Check it out!</a></body>
</html>