Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2008 Server
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
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