Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparing data Foxpro table against SQL server unicode
Message
From
06/05/2010 20:16:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Comparing data Foxpro table against SQL server unicode
Miscellaneous
Thread ID:
01463508
Message ID:
01463508
Views:
148
I placed data into cursor via sqlexec from SQL Server 2008 . Some Arabic text comes as "?????"
Previously SQL data was loaded from Foxpro also with sqlexec
and foxpro value was transformed to unicode like below before being put into Insert statement

xunicode = strconv(xutf8,12)
xres = 'convert(nvarchar(' + transform(len(xutf8)) + '),0x' + strconv(xunicode,15)+')'

So when compare values as they are :
from foxpro side I've got text with diacritical marks
from cursor side ?????

How can I compare those two on equality ?


foxpro without conversion
MOUSTAFA ABBES مصطفى عباس
sql cursor
MOUSTAFA ABBES ????? ????"

How it is seen in Server Management Studio
MOUSTAFA ABBES مصطفى عباس
Next
Reply
Map
View

Click here to load this message in the networking platform