Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT brings back values with spaces between characters
Message
From
11/02/2009 19:00:22
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01381074
Message ID:
01381084
Views:
44
This message has been marked as a message which has helped to the initial question of the thread.
>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
Map
View

Click here to load this message in the networking platform