General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
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!
>>
>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only