Information générale
Titre:
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 مصطفى عباس
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement