Database Field Size

At the moment the size of the field msg; in my table ozekismsout; is varchar 160. Due to I have to put in about 6 linefeeds, this needs by itself 30 characters. Can I increase this size of this field, so that I can put in the linefeeds (\0x0A)?

Answer:

Yes you can. You can set the size and type of the fields in both ozekismsout and ozekismsin to whatever you want. The only important thing is to make sure, the SQL statements on the database settings form can be executed on the modified tables.

Figure 1 - Increasing the field size of the SMS message in the database

Special characters such as linefeeds (0\x0A) are treated by Ozeki SMS as one character.

There is another advantage to creating longer field: you may send and receive SMS messages longer then 160 characters. These messages are called multi-part messages, because they are broken into two or three SMS messages during the delivery.

More information