WordPress database error: [Table 'wordpressredirection_404' already exists]
CREATE TABLE `wordpressredirection_404` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`url` varchar(255) NOT NULL DEFAULT '',
`agent` varchar(255) DEFAULT NULL,
`referrer` varchar(255) DEFAULT NULL,
`ip` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `created` (`created`),
KEY `url` (`url`),
KEY `ip` (`ip`,`id`),
KEY `referrer` (`referrer`)
) DEFAULT CHARACTER SET utf8;
I was looking at some of Coke’s SMS campaigns today and realized that unlike other SMS short codes which are 5 or 6 digits, they’re using a 4 digit short code. I couldn’t find much information about 4 digit short codes expect for the following from Qwasi below and that Sprint uses 4 digit short codes for free messages and self-service account management.
To start, if you noticed the short codes used by American Idol, you will quickly notice they use a 4-digit short code. These short codes are not considered to be a cross-carrier CSCs. Instead, that code is only available through that carrier – in this case AT&T. Sprint and Verizon often support these type of programs on their networks too using a 4-digit short code.
Does anyone have any more information on these 4 digit SMS short codes? Do you know if they bypass the Common Short Code Administration (CSCA) or work on all carriers? It would be interesting to see if the CSCA plans on releasing 4 or even 3 digit short codes sometime in the future. How much more would you pay for a 3 digit short code as compared to a 5 digit short code? Let me know in the comments below.