Environment versions
Network:
Windows 2003 Server
>Hey Gang
>
>I've got an issue I haven't seen before. Using SPT to get data from a third-party database. The query runs and brings back the results, but in VFP (Version 8), the data has extra spacing between each character. So the word ALEVE looks to foxpro like A L E V E
>
>I have attached a screen shot with debugger running, the same query in SA and the code that I'm calling. I'm guessing this is some kind of unicode issue. The database is SQL Server 2000.
>
>The field is 800 characters so it get returned as a memo, but that hasn't bothered me before. Since I don't have control of this database or the data, I'm trying to figure a way around this.
>
>
>Thanks for any advice
>
>Kirk
It is returning unicode (doublebyte) characters.
Previous
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