Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems reading froma SQL Server table
Message
De
11/03/2020 06:58:48
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01673522
Message ID:
01673524
Vues:
58
>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)

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform