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
>
>Some suggests
>
>Thanks
I found even this solution in Foxpro:
Maps remote Unicode data retrieved through SQL pass-through or remote views to ANSI.
SYS(987 [, lExpr])
Parameters
lExpr
True (.T.) - Unicode data is always fetched as ANSI. The ODBC driver performs the conversion from Unicode to ANSI.
False (.F.) (Default) - Unicode data is fetched as Unicode.
Collapse imageReturn Value
Logical data type. SYS(987) returns the previous setting.
If you call SYS(987) without the lExpr parameter, it returns current setting.
Collapse imageRemarks
SYS(987) can be used to return remote Varchar data as ANSI for use with
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