Support forum
Add Reply
Add Topic1:29 pm
QuoteThanks Henk, worked like a charm! 🙂
I tried "n" and "r" followed by \ but it didnt work, i think it was phpmyadmin fault. While using full query it worked in "SQL" option, but when using "Insert" option, and putting same value, it didnt work.
Thx again
9:23 am
May 28, 2013
Offline
Hello Dominik,
The right method to insert a newline character in a database field depends on the tool or programming language you use to create the database record. For instance, if you use an SQL query in MySQL Workbench you just use line breaks inside the field value:
VALUES ('+44xxxxxxxxxx','Line 1
Line 2
Line 3);
In MySQL Workbench, you can also use the Form Editor that allows you to directly type new lines in the database fields.
If you use PHP, C# or C++ you can use the newline escape character "\n", e.g.:
Other programming languages may require other methods to insert a newline character in a string.
Regards, Henk
8:32 pm
Hello Henk, i think Henrik wanted to know, how to insert data to SQL/MySQL table, to get following result in recieved message:
"The following orders has an error:
1234
5678
9101"
I tried to insert "A0x0AB0x0AC" into MessageText field of MessageOut table, hoping to recieve folloging sms:
"A
B
C"
but i got just "A0x0AB0x0AC". Tried "
" and "
" but nothing works.
So the question is, what should we insert int MessageText field to get linebreaks.
1:24 pm
May 28, 2013
Offline
Hello Henrik,
The SMS system uses the Line Feed character (decimal 10 or hexadecimal 0x0A) as a new line character. You can insert this character in the place of the comma's in your message to get the line breaks you want.
I am not entirely sure I fully understand your question, can you explain your question in more detail when I did not provide the correct answer?
Regards, Henk
11:08 am
I'm using SQL connector and would like to use linebreaks.
Example: "The following orders has an error: 1234, 5678, 9101"
should be sent as:
"The following orders has an error:
1234
5678
9101"
I have made a trigger on the messageIn table which sends the text back as an auto reply "SMS server has recived the command: "
When i copy the recived SMS from in to the out table the lineBreaks remains, but i can't see any linebreak code.
Most Users Ever Online: 529
Currently Online:
6 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 672
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1141
Posts: 3899
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1488