0

I have a web call to an ERP system that contains a product's information including its image. All the information that I got from the web call is then stored to its corresponding repository. eg: Call for Product's price goes to MyPriceRepository, call for Product's image goes to MyImageRepository. It's a call to WCF service.

Problem now is that the call for a product's image returns a string that is super long - larger than 65KB. Now, what option do I have to store that string? I see from here: https://github.com/ByteInternet/magento-installer/blob/master/lib/Varien/Db/Ddl/Table.php , we only have option as far as BLOB? How do I use MEDIUMBLOB?

Improve this question
4
  • Use SQL Create table instead of Modal to create Attribute.
    – HoangHieu
    May 29, 2018 at 8:09
  • I think, image is coming as byte code format. Try to convert into string.
    – MR.R DNATH
    May 29, 2018 at 8:24
  • The image is coming as string64 format, but it's really long - larger than 65KB. @HoangHieu Can you give more example of this? Right now does Magento support db's field using MEDIUMBLOB?
    – Farid
    May 29, 2018 at 8:40
  • You can't use EAV, new a module to control your image data. You can't use default magento, because table varchar of magento is text.
    – HoangHieu
    May 29, 2018 at 8:45

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.