Hi.
Firebird Embedded
Is it possible to insert via GUI new lines (be it LF or CRLF) in a table column?
So in a form’s multi-line text box it shows up as:
Line A
Line B
Line C
Line D
Tried
- Shift Enter
- Ctrl Enter
- \n
Thanks in advance!
In a multi line textbox is added ASCII_CHAR(10) for every linebreak. You couldn’t add this in a table and it won’t be seen in a table, if you have created such a multiline text content. It will all appear in one line.
I will get such multiline fields only in views with fields, which contain very much content (because concatenated from other fields) and set ASCII_CHAR(13) as a break. Don’t know the reason Base GUI will show this behavior - it will appear in the same field of a database I created for Firebird and also for MariaDB.
.
Tested a little bit more:
With Firebird the fields, which should show linebreaks, should be CLOB-fields. You will get a linebreak in this fields by shift+enter
Yes, to insert or update via SQL I know how:
‘Line 1’ || ASCII_CHAR(10) < + 13 if W > || ‘Line2’ || […]
Was wondering if it would be possible via Tables GUI. So it is not 
Yes, I know.
I can see it in form’s TextBox multiline.
understood.
Will try another time.
Thank you!
Have written this to show: It isn’t a special behavior of Firebird. You will need a LONGVARCHAR-field in HSQLDB, a CLOB-field in Firebird, might be also BLOB-fields in MariaDB.
To see multi lines in the tables grid GUI (?)
Is it this?
