Increase Field Size

I have done some changes to my FrontAccounting, but I need to get to the underlying tables in MySQL and perform the changes there. The reason is even though in Front Accounting I have made the changes the suspicion is the changes haven't taken at the MySQL level.

I have changed the field's length in the php code, but it still only reads the first 5 and not all that are entered. I really need the code to accept a longer location. Help. Thank you. We have locations that are for instance HFARGS12B10. This is coded saying which plant, which room, the storage device, the shelf or drawer and what bin or section. So when retrieving or storing something, we can go exactly to the proper place. There is no wasted time scouting for it.

Thank you.

Have a Blessed Day,
OfficeMgrBTI@Truevine.net

Have you tried posting to the MySQL forum? This one is for MS SQLServer..