I'm looking for some reference articles on how best to get a VFP COM object to be able to properly get/put unicode data from/to a SQL server database.
I've had some minor success but hitting a few snags like not being able to build a N'' string to SQLExec() up to the database. I can convert the unicode string to a series of nchar() function calls but that seems like a lot of unnecessary effort.
When I pull the data down the only success I've had is if the nvarchar fields are forced into VFP memos by setting the UseMemosize to 1 on the CursorAdapter object. I can then push the field data out to an HTML page and it's correctly displaying.
If I follow the advice from one of Steve Black's articles on enabling alternate language input at the OS level then VFP does in fact display the unicode text correctly browse windows and the like, but it breaks some other stuff on my box and I don't really feel like enabling every possible language on the machine.
The environment is VFP8, SQL2000 under Win2K and XP, along with ASP.
TIA