Subject: Re: explanation about table in mysql database - msg#00103

Previous Message by Date: click to view message preview

explanation about table in mysql database

i'm the one of gammu users. i use that to manage my message from mobile phone and maintain it using web interface using PHP language script. but i have some fields in some tables that i don't understand. here it goes : fields UDH and class in talble Inbox,outbox and sentintems. and fields TPMR in table sentitems. can you explain me about what information do they contain ?? or any documentation about all of them. i'll be thankfull for your answer. your regards,     firman Start your day with Yahoo! - make it your home page

Next Message by Date: click to view message preview

Re: explanation about table in mysql database

Sorry for the wrong information of my previous message: Wrong Link: >http://www.3gpp.org/ftp/tsg_t/TSG_T/TSGT_04/Docs/PDFs/TP-99124.pdf >Page 12 >9.2.3.24.1 Concatenated Short Messages The correct GSM 03.04 document is here https://www.scriptlance.com/cgi-bin/freelancers/files.cgi?f=gsmts_0340v050300p.pdf&id=1097840251&t=p Page 57 9.2.3.24.1 Concatenated Short Messages >For each sms, it is limited to 160 ansi character. If >it is more than 160, then 153 will save the actual >data. The other 7 will store the information like >"Page 2 of 4". This is one of the usage of UDH. Each sms occupies 140 byte => 140 x 8bit. Therefore, 160 ansi character only valid for 7-bit data. 140 x 8 / 7 = 160. In case the short message need to be concatenated, 134 byte can be used to store the content. The rest 6 is used to make the header. Sorry to make everybody confuse. I will try to stay calm in the future. Kwan _______________________________________ 想即時收到新 email 通知？ 下載 Yahoo! Messenger http://messenger.yahoo.com.hk ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ Gammu-users mailing list - https://lists.sourceforge.net/lists/listinfo/gammu-users

Previous Message by Thread: click to view message preview

explanation about table in mysql database

i'm the one of gammu users. i use that to manage my message from mobile phone and maintain it using web interface using PHP language script. but i have some fields in some tables that i don't understand. here it goes : fields UDH and class in talble Inbox,outbox and sentintems. and fields TPMR in table sentitems. can you explain me about what information do they contain ?? or any documentation about all of them. i'll be thankfull for your answer. your regards,     firman Start your day with Yahoo! - make it your home page

Next Message by Thread: click to view message preview

Re: explanation about table in mysql database

thanx lot for ur ans.. and what bout TPMR. do u have any known about that ???? i would be thankful for ur answer --- Cheung Hok Kwan <mailkwan@xxxxxxxxx> wrote: > > fields UDH and class in talble Inbox,outbox and > > sentintems. > > and fields TPMR in table sentitems. > > I am also new to gammu and sms area but this is the > best from my knowledge. > > For each sms, it is limited to 160 ansi character. > If > it is more than 160, then 153 will save the actual > data. The other 7 will store the information like > "Page 2 of 4". This is one of the usage of UDH. > > For document: > http://www.3gpp.org/ftp/tsg_t/TSG_T/TSGT_04/Docs/PDFs/TP-99124.pdf > Page 12 > 9.2.3.24.1 Concatenated Short Messages > > Or extract from source code gsmsms.c > > /* > * 1 byte 0x00 > * 1 byte 0x03 > * 1 byte 0x01: unique ID for message series > * 1 byte 0x00: how many SMS in sequence > * 1 byte 0x00: number of current SMS in sequence > */ > > Kwan > > > _______________________________________ > ·Q§Y®É¦¬¨ì·s email ³qª¾¡H > ¤U¸ü Yahoo! Messenger http://messenger.yahoo.com.hk > > > > ------------------------------------------------------- > SF.Net email is Sponsored by the Better Software > Conference & EXPO > September 19-22, 2005 * San Francisco, CA * > Development Lifecycle Practices > Agile & Plan-Driven Development * Managing Projects > & Teams * Testing & QA > Security * Process Improvement & Measurement * > http://www.sqe.com/bsce5sf > _______________________________________________ > Gammu-users mailing list - > https://lists.sourceforge.net/lists/listinfo/gammu-users > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ Gammu-users mailing list - https://lists.sourceforge.net/lists/listinfo/gammu-users