Now Sms ID, what is MAX length?

Now Sms ID, what is MAX length? SearchSearch
Author Message
Volodumyr Mandrychenko
New member
Username: Vmandrychenko

Post Number: 1
Registered: 09-2007
Posted on Tuesday, December 18, 2007 - 03:38 pm:   

As we know Now Sms generates ID for each MT (outgoing message). ID looks like this: 477F1762.req or SAR-19512071164-f1-2-2 for split messages.

When we receive delivery reports we are performing a look up by Now Sms ID to update status of the message. Since now sms ID length changes our look up index is a 'varchar' which causes significant loading problems in our database.

We would like to convert the now sms id database feild to 'char' and we need to know what is the max possible length of ID returned by now sms.

Please list max possible length for "SAR-" ids messages and ".req" ids.

Thanks

Volodymyr