Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to set character length when adding a new field to the database


djmonkey1

Recommended Posts

I've got the following sql query:

 

INSERT INTO configuration SET configuration_title='Set "Contact Us" Email List', date_added=NOW(), sort_order='11', configuration_group_id='1', configuration_key='CONTACT_US_LIST', configuration_value= '', configuration_description='On the "Contact Us" Page, set the list of email addresses , in this format: Name 1 <email@address1>, Name 2 <email@address2>', use_function = NULL , set_function = NULL;

 

But the value of the corresponding text box that's created is too small, only 255 characters. How should this sql query be written to change this? I want to have a text field of unlimited length.

 

Thanks

Stew

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

It is not the query you need to change but the data type in the database for that field.

 

http://dev.mysql.com/tech-resources/articl...-datatypes.html

 

I don't see an option to do that from within my database manager.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...