Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can photos be stored in VFP?
Message
De
09/11/2008 21:13:41
 
 
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:
01360819
Vues:
8
Sergey,

Thanks. How about our Memo Binary field? What is it's counterpart in MySQL?

Dennis

>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!
>>
>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform