General information
Title:
Comparing data Foxpro table against SQL server unicode
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
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