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 по дате отправления:

Предыдущее
От: TJ O'Donnell
Дата:
Сообщение: dynamically loaded functions
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: dynamically loaded functions