SoireeExtreme Posted November 20, 2006 Share Posted November 20, 2006 Sorry if this isn't the right place to ask this. But I don't know mysql very well nor php for that matter.But I have a forum. And it only allows you to type so many characters. So you can't say all you have to say in one post you would have to type 2 or 3 pots just to get your point across. How would I get the database to save move characters? Or a bigger post so to speak? Thanks if anyone can help. Quote Link to comment https://forums.phpfreaks.com/topic/27822-storeage-length/ Share on other sites More sharing options...
printf Posted November 20, 2006 Share Posted November 20, 2006 change the column type[code]ALTER TABLE table_name CHANGE column_name column_name TEXT NOT NULL;[/code]If your using VARCHAR, you could switch to TEXT, with the query above.[code]ALTER TABLE table_name CHANGE column_name column_name MEDIUMTEXT NOT NULL;[/code]If your using TEXT, you could switch to MEDIUMTEXT, with the query above.To be safe always check your table column type before altering it, Also if your using MySQL 5 and some versions of MySQL 4 you can add the language settings for that column when you alter it!// example...[code]ALTER TABLE table_name CHANGE column_name column_name TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;[/code]But read the manual [url=http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html]storage types and requirements[/url], to learn the best way to change your table or column settings...printf Quote Link to comment https://forums.phpfreaks.com/topic/27822-storeage-length/#findComment-127329 Share on other sites More sharing options...
fenway Posted November 20, 2006 Share Posted November 20, 2006 Just remember that variable length fields means that your table would no longer be fixed-width. Quote Link to comment https://forums.phpfreaks.com/topic/27822-storeage-length/#findComment-127609 Share on other sites More sharing options...
SoireeExtreme Posted November 25, 2006 Author Share Posted November 25, 2006 But how do you set the tables to store more. As I'm using Varchar(255) and it stores like nothing. And I don't understand these manuels. Because people don't know how to make things straight forward. Grrr... Quote Link to comment https://forums.phpfreaks.com/topic/27822-storeage-length/#findComment-129859 Share on other sites More sharing options...
AndyB Posted November 25, 2006 Share Posted November 25, 2006 [quote author=SoireeExtreme link=topic=115600.msg473369#msg473369 date=1164416417]But how do you set the tables to store more. [/quote]Read the answers given here. Hint - change the field type from varchar to text Quote Link to comment https://forums.phpfreaks.com/topic/27822-storeage-length/#findComment-129872 Share on other sites More sharing options...
SoireeExtreme Posted November 25, 2006 Author Share Posted November 25, 2006 Sorry thanks. My head is hurting and I'm not thinking straight. Quote Link to comment https://forums.phpfreaks.com/topic/27822-storeage-length/#findComment-129882 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.