I got a problem with setting up a table that includes a text field i phpMyAdmin. The main idea is that the text field is gonna contain text of variable length in my database. (I'm using it for news segments and stuff like that)
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(1000) NOT NULL, `author` VARCHAR(10) NOT NULL, `viewed` INT NO
I must have been doing something wrong because the first
time I tried to create a table with a TEXT field without a length I also got an error saying something like I should specify one, but something else must have been wrong then.. Oh well it's working now
Just another question after I've read the manual. Is BLOB used for images?
blob is used for binary data.. but we'll recommend not using it for images as they are accessed far too often, each image from the database will require a seperate page request and database query. You'll add a bunch of time to load any image from the server.