Setting default line break to Unix in tables and/or fields

[expired user #9012]'s profile image [expired user #9012] posted 9 years ago in General Permalink
Is there a way to define the default line break type for fields or tables? Heidi defaults to windows line breaks \r\n, I use unix line breaks. It is tedious to have to manually modify each record to use Unix line breaks.
ansgar's profile image ansgar posted 9 years ago Permalink
You mean the line break button in the popup text editor of the data grid?
[expired user #9012]'s profile image [expired user #9012] posted 9 years ago Permalink
Yes, that is the only way I can see to modify the line break method. It has to be done for each field in each record. I was hoping there might be a way to set this globally for all records in a field in the options tab.
[expired user #9012]'s profile image [expired user #9012] posted 9 years ago Permalink
Of course, this would mostly likely apply only to text fields......
Code modification/commit from ansgarbecker, 9 years ago, revision 9.2.0.4963
Introduce option for setting the line break style in text cells without breaks. See http://www.heidisql.com/forum.php?t=18682
ansgar's profile image ansgar posted 9 years ago Permalink
r4963 adds a new option for setting the default line break style, in Tools > Preferences > "Editor configuration".

This setting defaults to Windows linebreaks. If set to Unix linebreaks for example, HeidiSQL will detect empty text cells or cells without a break as Unix style.
[expired user #9012]'s profile image [expired user #9012] posted 9 years ago Permalink
That works, thanks for the quick fix!
[expired user #9012]'s profile image [expired user #9012] posted 9 years ago Permalink
Would it be possible to add the same linebreak set cropdown for all records in a field in the table::basic or table::options view? That way folks who don't know what they are doing or have existing tables can globally fix the data later.

Please login to leave a reply, or register at first.