<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=805050022-26122007><FONT face=Arial>I saw this post on the
Autodesk Map Discussion Group and thought some folks here might find it
interesting. See below.</FONT></SPAN></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left>Tripp Corbin, MCP,
CFM, GISP</P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left>Vice President,
GIS/Mapping</P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><I>ESRI Authorized
Instructor</I></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><B>Keck & Wood,
Inc.</B></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><A
href="http://www.keckwood.com/"><FONT color=#0000ff><U><FONT
size=2>www.keckwood.com</FONT></U></FONT></A></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><FONT size=2>(678)
417-4013</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><FONT size=2>(678)
417-8785 fax</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><FONT
face=Arial></FONT> </P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><B>Keck & Wood,
Inc</B> offers a range of GIS services and training.<BR>Please visit <A
href="http://www.keckwood.com/"><FONT
color=#0000ff><U>www.keckwood.com</U></FONT></A> for more information including
a schedule of upcoming classes.<BR><BR><BR>RE: FDO support for SDE 9.2, lessons
learned. <BR><BR>I created this post to consolidate information from
several posts related to ARC SDE 9.2. The two main issues related to FDO
support for SDE 9.2 are high precision data in ARC and the nvarchar data type on
the server back-end.<BR><BR>I hope this helps someone because I could have used
this information six months ago.<BR><BR>We have are getting ready to move to ARC
SDE 9.2 and learned the following:<BR><BR>FDO in Map 2008 does not support data
stored in high precision format in SDE 9.2. There is a lot of good
information related to the difference between high accuracy and high
precision data and the pro’s and cons. My SDE administrator now knows not
convert our low precision data for features intended to be extracted by Map
users, for now. I only seem to have this problem with Map 2008. Map
2006 and 2007 connected to SDE 9.2 and extracted high precision data for
me. Go figure.<BR><BR>FDO in any release does not support the data type
nvarchar used by the backend database SQL or Oracle. You do not see this
in ArcCatalog, you need to use the DB tools. If you convert data to the
nvarchar format, FDO will drop the attribute columns using this data type when
you connect. I could see my road but not the road names. My SDE
administrators found that SDE will automatically convert the data from varchar
to nvarchar for you by default during an upgrade. You can add a line item
to the SDE config file to flag ARC to use the old varchar to be the
default.<BR><BR>FYI nvarchar is the Unicode standard and varchar is the ANSI
standard. The Unicode standard allows for international characters but
takes twice as much memory.<BR><BR>Mark Nelson<BR>Idaho Power.
<DIV> </DIV></BODY></HTML>