topic Re: VARCHAR instead of NVARCHAR in Data Management Questions https://community.esri.com/t5/data-management-questions/varchar-instead-of-nvarchar/m-p/121575#M6973 <HTML><HEAD></HEAD><BODY><SPAN>This is written for Oracle, but I expect it will work for SQL-Server too.</SPAN><BR /><SPAN> </SPAN><BR /><A href="http://resources.arcgis.com/content/kbase?fa=articleShow&amp;d=36459">http://resources.arcgis.com/content/kbase?fa=articleShow&amp;d=36459</A><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Fri, 11 Mar 2011 17:25:51 GMT VinceAngelo 2011-03-11T17:25:51Z VARCHAR instead of NVARCHAR https://community.esri.com/t5/data-management-questions/varchar-instead-of-nvarchar/m-p/121574#M6972 <HTML><HEAD></HEAD><BODY><SPAN>When I make an XY Event into a new SDE feature class it automatically converts VARCHAR to NVARCHAR. Is there a setting I am missing to stop this from happening?</SPAN><BR /><BR /><SPAN>I have tried 'Copy Features' and 'Feature Class to Feature Class' and both do the same thing.</SPAN><BR /><BR /><SPAN>I am importing a table from a dev box into our SDE. As a table in dev, all of the fields are VARCHAR but when it becomes spatial it automatically converts to NVARCHAR. I then either manually change them back in SQL Server or run a script (depends on my mood).</SPAN><BR /><BR /><SPAN>Any ideas?</SPAN></BODY></HTML> Fri, 11 Mar 2011 17:02:57 GMT https://community.esri.com/t5/data-management-questions/varchar-instead-of-nvarchar/m-p/121574#M6972 JimW1 2011-03-11T17:02:57Z Re: VARCHAR instead of NVARCHAR https://community.esri.com/t5/data-management-questions/varchar-instead-of-nvarchar/m-p/121575#M6973 <HTML><HEAD></HEAD><BODY><SPAN>This is written for Oracle, but I expect it will work for SQL-Server too.</SPAN><BR /><SPAN> </SPAN><BR /><A href="http://resources.arcgis.com/content/kbase?fa=articleShow&amp;d=36459">http://resources.arcgis.com/content/kbase?fa=articleShow&amp;d=36459</A><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Fri, 11 Mar 2011 17:25:51 GMT https://community.esri.com/t5/data-management-questions/varchar-instead-of-nvarchar/m-p/121575#M6973 VinceAngelo 2011-03-11T17:25:51Z