General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLEXEC() and nvarchar datatypes
In regards to how in VFP 8.0 when you issue a SQLEXEC() to create a cursor from a SQL table, all nvarchar type fields translate to VFP as memo fields with unicode. I know of two ways around the unicode, one by using a CAST in the SQL statement, the other using STRTRAN() on the memo field in the VFP cursor.
My question is this, is there some sort of global setting or anything that can be used to avoid either of those two solutions and have the nvarchar types come over to foxpro without the unicode? We have many, many SQL statements and we would like to not have to edit all that code if there is a global setting that can be done.
Thanks in advance,
Mike
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only