Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can photos be stored in VFP?
Message
 
 
To
09/11/2008 20:15:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01360739
Message ID:
01360818
Views:
12
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform