Question: In the SQL table what are all the possible message status eg"send, sent,
transmited, delivered"?

This page gives you all the possible values:
Message state updates

OZEKI MESSAGE SERVER 6 -  SMS PROBLEM WITH QUOTES

 When I receive an SMS, sometimes my messages are not inserted into the database.

When a message is received, an SQL string is composed, then it is passed to the database server. The SQL string composition is based on an SQL template defined in the Database Settings form. If an incoming message contains an apostrophe (') or a quotation mark ("), the SQL statement becomes invalid when the message text is inserted into the template.

Our software provides a mechanism to replace the apostrophe (') and the quotation mark (") in the received message before it is inserted into the SQL template. On the Database settings form you can specify what caracter sequence should be used instead of these characters.

Note: On Sybase, MSSql and on MySql, you should substitue the apostrophe (') with backslash and apostrophe (\') and you should do the same for quotation marks.

 

ozeki sql sms server configuration
Figure 1 - Ozeki sql sms server configuration

ozeki sql sms server table
Figure 2 - Ozeki sql sms server table

More information