>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)