SQL Templates

Ozeki Message Server uses SQL templates, to communicate with the Database Server. When an SQL action needs to be taken, the appropriate SQL template is selected and the keywords in the template are replaced to the corresponding elements in the message.

The SQL templates can be modified if the tables structure is different from the default. The SQL templates can be changed on the SQL templates tab of the Database plugin configuration form (Figure 1).

sms sql database plugin template
Figure 1 - SQL Templates

On the bottom of the SQL template tab of the database configuration form you can define character replacements. This is necessary because 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.

Ozeki message server 6 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 character sequence should be used instead of these characters.

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

More information