VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 VP-ASP 6.00 Questions
 Change field from text to memo
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

28 Posts

Posted - April 25 2006 :  17:20:36  Show Profile  Reply with Quote
I am considering changing the type of field for Keywords in 6.00 from a text field into a memo field. The text field is limited to 255 characters and I want to use the Keyword field as the meta keyword field for SEO. However, I need more than 255 characters to properly do this. Before I do this, is there anything that I should be concerned with? Please let me know.


Starting Member

34 Posts

Posted - May 04 2006 :  16:58:10  Show Profile  Reply with Quote
Memo fields are treated differently from text fields by the database itself. Changing a text to a memo can have effects such as:

Some fields following the memo field may not retrieve data properly.
Memo fields cannot be searched.

If you switch from Access to SQL server database, you can have varchar (same as text) that are larger than 255 characters.

Howard Kadetz

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000