0

enter image description here

I cannot make my update longer than 32 characters. How can I change this so it saves characters up to 140?

This is my first ever day of working with a database so please be nice. :)

Isaac Bennetch
  • 11,830
  • 2
  • 32
  • 43
Mia
  • 817
  • 2
  • 8
  • 13
  • 2
    That's a nice GIF, but we can't really do anything but guess when you aren't showing us the (full) code. Is this message stored in a database? If so, it might be a length issue. – Qirel Feb 17 '16 at 15:30
  • 1
    Maybe changing property of your field in table structure (phpMyAdmin): change `VARCHAR (32)` in `VARCHAR (140)` (or `CHAR`, depending of your field type) – fusion3k Feb 17 '16 at 15:30
  • @fusion3k I've tried looking for that but cannot find it, maybe you can guide me to it? – Mia Feb 17 '16 at 15:31
  • @Mia You'll need to find the table and column where this data is being stored in the database (check the code where it updates) - then modify the type of it to increase the length it accepts (you can do this using phpMyAdmin). – Qirel Feb 17 '16 at 15:34
  • What type of database are you using (SQL, MySQL, etc.)? – Maverick976 Feb 17 '16 at 15:40
  • @Maverick976 look at tags... – fusion3k Feb 17 '16 at 15:42
  • Possible duplicate of [How can I modify the size of column in a mysql table?](http://stackoverflow.com/questions/1279568/how-can-i-modify-the-size-of-column-in-a-mysql-table) – Ageonix Feb 17 '16 at 16:15

1 Answers1

2

coherent answer

In our phpMyAdmin, select “structure” on your table list, then select “change” at the right of your field (“Message”) and increase the “Length/Value” type.

fusion3k
  • 11,568
  • 4
  • 25
  • 47