Reputation: 264
I'm gonna write SMS service that sends SMS's automatically.In that case i am going to create my SMS content by SQL.
So is it possible to add a line break by using some special command or a character?
Upvotes: 0
Views: 1780
Reputation: 264
i have concatenate CHAR(10) to my SQL message content an it worked !!!
Upvotes: 2
Reputation: 2557
Have you tried \n? I notice you say you've tried forward slash... Give back slash a try.
If that doesn't work, since you have tried the line feed character already (%0A), try carriage return (%0D) or a combination of the two (%0A%0D)
Edit: To let us help you better, what are you using to write this service? What technologies are involved here?
Upvotes: 0