Rob's TIMSS Blog

My discoveries and ramblings of TIMSS/Personify.

Monday, October 29, 2007

Customer URL Format

In TIMSS and Personify, you can store a URL for a customer which can be up to 100 characters long (data type of EMAIL_ADDRESS).

The question often comes up if one should store the URL with the leading http:// or leave that off. I found it best to add it in, that way whenever I'm working with the URL most programs will recognize it as such and make it a link.

However, because the field only holds 100 characters and some URLs are very long, you might want to save the extra 7 characters an not include the http://.

The most important thing is that your data is consistent. If all the URLs don't have the http:// you can always add it in later when pull the data.

Also if you find yourself continuously having URLs that are too long, you can always change the data type for EMAIL_ADDRESS to be longer.

Applies to: TIMSS6 & Personify

0 Comments:

Post a Comment

<< Home