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

[expired user #9012]'s profile image [expired user #9012] posted 10 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 10 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 10 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 10 years ago Permalink
Of course, this would mostly likely apply only to text fields......
Code modification/commit 59159c7 from ansgarbecker, 10 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 10 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 10 years ago Permalink
That works, thanks for the quick fix!
[expired user #9012]'s profile image [expired user #9012] posted 10 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.