Thread: [adminer-tracker] [ adminer-Bugs and Features-3404333 ] \n is stripped out of varchar fields?
Database management in a single PHP file
Brought to you by:
jakubvrana
From: SourceForge.net <no...@so...> - 2011-09-05 16:42:14
|
Bugs and Features item #3404333, was opened at 2011-09-05 18:42 Message generated for change (Tracker Item Submitted) made by starenka0 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3404333&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Common Group: 3.3.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: starenka (starenka0) Assigned to: Jakub Vrána (jakubvrana) Summary: \n is stripped out of varchar fields? Initial Comment: I've accidentaly executed sql like this (via adminer): INSERT into cms_redirect VALUES(NULL,'/o-nas/pro-media/zdvojnasobeni-poctu-klientu-na-5000/ ','/pro-media/zdvojnasobeni-poctu-klientu-na-5000/ ','1'); which contains newline in the second varchar field. Adminer doesn't show the newline character neither in item listing nor while editing the item. table struct: Column Type Comment id int(11) Auto Increment path varchar(255) redirect_to varchar(255) site_id int(11) IndexesPRIMARY id UNIQUE site_id, path INDEX path INDEX redirect_to INDEX site_id ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3404333&group_id=264133 |
From: SourceForge.net <no...@so...> - 2011-09-05 16:44:01
|
Bugs and Features item #3404333, was opened at 2011-09-05 18:42 Message generated for change (Comment added) made by starenka0 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3404333&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Common Group: 3.3.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: starenka (starenka0) Assigned to: Jakub Vrána (jakubvrana) Summary: \n is stripped out of varchar fields? Initial Comment: I've accidentaly executed sql like this (via adminer): INSERT into cms_redirect VALUES(NULL,'/o-nas/pro-media/zdvojnasobeni-poctu-klientu-na-5000/ ','/pro-media/zdvojnasobeni-poctu-klientu-na-5000/ ','1'); which contains newline in the second varchar field. Adminer doesn't show the newline character neither in item listing nor while editing the item. table struct: Column Type Comment id int(11) Auto Increment path varchar(255) redirect_to varchar(255) site_id int(11) IndexesPRIMARY id UNIQUE site_id, path INDEX path INDEX redirect_to INDEX site_id ---------------------------------------------------------------------- >Comment By: starenka (starenka0) Date: 2011-09-05 18:43 Message: In fact the newline was in both varchar fields, but I think you got the point... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3404333&group_id=264133 |
From: SourceForge.net <no...@so...> - 2011-09-05 20:29:17
|
Bugs and Features item #3404333, was opened at 2011-09-05 18:42 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3404333&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Common Group: 3.3.3 >Status: Closed >Resolution: Wont Fix Priority: 5 Private: No Submitted By: starenka (starenka0) Assigned to: Jakub Vrána (jakubvrana) Summary: \n is stripped out of varchar fields? Initial Comment: I've accidentaly executed sql like this (via adminer): INSERT into cms_redirect VALUES(NULL,'/o-nas/pro-media/zdvojnasobeni-poctu-klientu-na-5000/ ','/pro-media/zdvojnasobeni-poctu-klientu-na-5000/ ','1'); which contains newline in the second varchar field. Adminer doesn't show the newline character neither in item listing nor while editing the item. table struct: Column Type Comment id int(11) Auto Increment path varchar(255) redirect_to varchar(255) site_id int(11) IndexesPRIMARY id UNIQUE site_id, path INDEX path INDEX redirect_to INDEX site_id ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2011-09-05 22:29 Message: There's no way to display newline in <input>. But take a look at plugin edit-textarea. http://www.adminer.org/en/plugins/ ---------------------------------------------------------------------- Comment By: starenka (starenka0) Date: 2011-09-05 18:43 Message: In fact the newline was in both varchar fields, but I think you got the point... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3404333&group_id=264133 |