Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I'm having problems reading data froma SQL Server 2016 table. I can read the values in all fields, but in some characters field i have a space beteween every letter
>>
>>In SQL Server database management i can see al data normally. For example i have a field called description that contains this string
>>"This string"
>>
>>When i open this table in foxpro with a remote view this field is a Memo field and the value is
>>"T h i s s t r i n g"
>>
>>I have already read data from SQL server database and i never had this problem....
>>
>>Used both SQL Server Native client 11 or the generic SQL server odbc driver
>
>The fields come down in unicode, which fox doesn't handle directly. Either get them converted sql side, as Martina said, or fox side, using
>
>lcString=strconv(strconv(lcUnicodeString, 6),2)
Thanks
Précédent
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