Storeage Length

[SoireeExtreme]

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.

[printf]

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

[fenway]

Just remember that variable length fields means that your table would no longer be fixed-width.

[SoireeExtreme]

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...

[AndyB]

[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

[SoireeExtreme]

Sorry thanks. My head is hurting and I'm not thinking straight.