Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can photos be stored in VFP?
Message
 
 
À
09/11/2008 20:15:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01360739
Message ID:
01360818
Vues:
10
Hi Dennis,

In general, it's better to store images as files with links stored in a table. You can use Blob if you have requirement to store images in a table. MySql has Blob type as well. Actually it has four blob types of different max size.

>
>You can store them in Blob field but remember that FPT file cannot be bigger than 2GB.
>
>So, would you suggest storing photo files (jpegs) less than 2Gb in Blob fields rather than just storing the photo file location?
>
>Same as well with storing in SQL or MySQL?
>
>As an aside, what is MySQL's counterpart for our Memo (Binary) field? Is it VARBINARY or TEXT (Text does not have a 'binary' type)?
>
>Thanks!
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform