The first question was what to chose for displaying unicode data? prefs_sl.language09 as nvarchar(100)), lngimage09 = ? A big thanks to Gregory for helping me with the code – I don’t know where I would be without his help.Rick mentioned MS Edit Box control Active X, but I didn’t find it in the list of my installed Active X. prefs_sl.language08 as nvarchar(100)), lngimage08 = ? Olaf Doschke showed another way which is even simpler than implemented solution and in accordance to the original Rick’s article.Once you register for an account you will have immediate access to the forums and all past articles and commentaries.azure book business intelligence c# database excel gotcha how to mongodb nosql performance security sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 ssis ssms ssrs syndicated t-sql tip unit testing Recently I had to deal with the problem of displaying and saving Unicode data in a Visual Fox Pro form.
Ok, we all know the classical and very comprehensive article on this topic written by Rick Strahl Using Unicode in Visual Fox Pro Web and Desktop Applications. Our application uses SQL Server to hold data and uses sql pass thru technique to send information from and to SQL Server.
Of course, it takes a few more steps than that, but the point is that with Visual Studio 6.0 Database Tools, you can take advantage of several SQL Server 7.0 features to make your enterprise data tasks easier and more efficient.
You can use the information in this article if you have either of these combinations of tools: To access heterogeneous OLE DB data sources and deal with enterprise data work, a powerful, flexible solution is the linked server feature.
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance.
Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.