vwinstead Posted February 5, 2009 Share Posted February 5, 2009 I'm accessing a mySQL database with PHP. I'm using phpMyAdmin to alter my table data. In order to insert a value manually into a field which is of BLOB type it requires me to browse to a BINARY file (Max: 65,536B). What does that mean? How do you make a binary file in the appropriate format for this? Link to comment https://forums.phpfreaks.com/topic/143943-binary-field-for-blob-in-phpmyadmin/ Share on other sites More sharing options...
flyhoney Posted February 5, 2009 Share Posted February 5, 2009 A binary file can be an image or an .exe or .bin, it can be a lot of things. What are you storing in that column? Link to comment https://forums.phpfreaks.com/topic/143943-binary-field-for-blob-in-phpmyadmin/#findComment-755328 Share on other sites More sharing options...
vwinstead Posted February 5, 2009 Author Share Posted February 5, 2009 A binary file can be an image or an .exe or .bin, it can be a lot of things. What are you storing in that column? I'm using just a big block of text. I wanted it in BLOB format to allow for expansion. Can I make a .bin file from something as simple as notepad? Link to comment https://forums.phpfreaks.com/topic/143943-binary-field-for-blob-in-phpmyadmin/#findComment-755338 Share on other sites More sharing options...
flyhoney Posted February 5, 2009 Share Posted February 5, 2009 Text is inherently not binary. Why not use a TEXT field or LARGETEXT instead? Link to comment https://forums.phpfreaks.com/topic/143943-binary-field-for-blob-in-phpmyadmin/#findComment-755340 Share on other sites More sharing options...
vwinstead Posted February 5, 2009 Author Share Posted February 5, 2009 Text is inherently not binary. Why not use a TEXT field or LARGETEXT instead? how big can the LARGETEXT type get? Link to comment https://forums.phpfreaks.com/topic/143943-binary-field-for-blob-in-phpmyadmin/#findComment-755346 Share on other sites More sharing options...
flyhoney Posted February 5, 2009 Share Posted February 5, 2009 From the docs LONGBLOB, LONGTEXT L + 4 bytes, where L < 2^32 So... 4 Gigs? (and sorry, its LONGTEXT not LARGETEXT, my bad) Link to comment https://forums.phpfreaks.com/topic/143943-binary-field-for-blob-in-phpmyadmin/#findComment-755353 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.