j05hr Posted October 29, 2009 Share Posted October 29, 2009 Hi, I'm using phpmyadmin version 5.1.39 and I can't seem to find a type to upload images. I know on Microsoft SQL Server you get a file type called image but I thought you did on phpmyadmin too, These are all the options I have, what should I use? INT VAR TEXT DATE TINYINT SMALLINT MEDIUMINT INT BIGINT DECIMAL FLOAT DOUBLE REAL BIT BOOT SERIAL DATE DATETIME TIMESTAMP TIME YEAR CHAR VARCHAR TINYTEXT TEXT MEDIUMTEXT LONGTEXT BINARY VARBINARY TINYBLOB MEDIUMBLOB BLOB LONGBLOB ENUM SET GEOMETRY POINT LINESTRONG POLYGON MULTIPOINT MULTILINESTRING MULTIPOLYGON GEOMETRYCOLLECTION Link to comment https://forums.phpfreaks.com/topic/179512-phpmyadmin/ Share on other sites More sharing options...
jonsjava Posted October 29, 2009 Share Posted October 29, 2009 BLOB is the type that you use to store binary data. This is the one you will want to use. Please read here for more info on blob Link to comment https://forums.phpfreaks.com/topic/179512-phpmyadmin/#findComment-947227 Share on other sites More sharing options...
j05hr Posted October 29, 2009 Author Share Posted October 29, 2009 Thanks for the help, it let me load a file in the database but then when I viewed it, it didn't show the image, and just load of random text and signs. Link to comment https://forums.phpfreaks.com/topic/179512-phpmyadmin/#findComment-947249 Share on other sites More sharing options...
jonsjava Posted October 29, 2009 Share Posted October 29, 2009 you've gotta set the content type on output, or it reads it as text. kinda nasty, but that's how it works. Link to comment https://forums.phpfreaks.com/topic/179512-phpmyadmin/#findComment-947252 Share on other sites More sharing options...
j05hr Posted October 29, 2009 Author Share Posted October 29, 2009 How do I do this? I searched it on google but couldn't find anything relevant. Link to comment https://forums.phpfreaks.com/topic/179512-phpmyadmin/#findComment-947258 Share on other sites More sharing options...
Daniel0 Posted October 29, 2009 Share Posted October 29, 2009 How do I do this? I searched it on google but couldn't find anything relevant. header Link to comment https://forums.phpfreaks.com/topic/179512-phpmyadmin/#findComment-947260 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.