Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving Binary File to/from SQL*Server
Message
De
04/11/2001 12:10:30
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00577111
Message ID:
00577203
Vues:
16
> Kevin,
>Use Image type that maps to general in VFP. It can store any type of file as binary.
>Binary and varbinary has limitations in that they shouldn't exceed 8KB and for binary every row should have the same fixed length.
>Cetin

>
>Cetin,
>
>Thanks for the input. Would using a memo field in the VFP cursor cause any problems versus using a general field?
>
>kevin

Memo would have problems if you don't care of data is 'binary' and code page conversions should be avoided. General fields are in fact memo fields. You could anytime save a file stored in general or memo field to disk or the reverse. General fields are of course slightly different in fpt at least in their header bytes.
Inage datatype maps to general in VFP and varchar, nvarchar to memo. If you'd go memo way than use varchar. You'd decide in which to store on where would you store it if used pure VFP. Image directly stores binary data where text stores nonunicode data that's in code page of the server. Since there are tricks to write general field content to a file I think I'd go with Image datatype.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform