Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comparing data Foxpro table against SQL server unicode
Message
De
06/05/2010 20:16:17
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Comparing data Foxpro table against SQL server unicode
Divers
Thread ID:
01463508
Message ID:
01463508
Vues:
147
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
Fil
Voir

Click here to load this message in the networking platform