Welcome, Guest ( Customer Panel | Login )




 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  

bagman74
Starting Member

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

Mark

hk777
Starting Member

Australia
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
0 Item(s)
$0.00