How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format
От | Dinesh Pandey |
---|---|
Тема | How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format |
Дата | |
Msg-id | 200507120342.j6C3gR1O005118@postman.bayarea.net обсуждение исходный текст |
Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format, becausewhile storing <b><span style="font-weight:bold">\f</span></b> treats data in strange way.</span></font><p class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">Example: ‘This is sample data <b><font color="blue"><span style="color:blue;font-weight:bold">\n</span></font></b><b><span style="font-weight:bold">\r</span></b>oot<b><span style="font-weight:bold">\f</span></b>iles.txt,<b><span style="font-weight:bold">\r</span></b>oot<b><span style="font-weight: bold">\te</span></b>xt.txt’</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">Sol: One way replaces \ with \\</span></font><p class="MsoNormal"><font face="Verdana" size="2"><spanstyle="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt">Thanks</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt">Dinesh</span></font></div>
В списке pgsql-sql по дате отправления: