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 Quote 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 Quote 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. Quote 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. Quote 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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/179512-phpmyadmin/#findComment-947260 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.