Hi again, I'm inserting some test products into my new mysql database but it only lets me enter so much? I thought BLOB would allow alot more characters? Anyway, this was how I constructed the database.....

CREATE TABLE jspCart_products (
ProductID int primary key,
CategoryID int,
ModelNumber varChar(75),
ModelName varChar(250),
ProductImage varchar(250),
UnitCost decimal(9,2),
Description BLOB,
);

This is what I am trying to enter...
INSERT into jspCart_products VALUES(188, 4, "f23", "modelxyz","../images/product1.jpg", 20.95,"Hi my name is frank and I'd like to say like WOW man.This is a lengthy description of this product. It is A numero Uno on my list like wow I love this product so much it is unbelievable!");


But it only lets me type in the command window this much....
INSERT into jspCart_products VALUES(188, 4, "f23", "modelxyz","../images/product1.jpg", 20.95,"Hi my name is frank and I'd like to say like WOW man.This is a lengthy description of this product.


Can someone help me out here?
Thanks in advance,
-Wiley


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to