数据转义符问题
从oracle中读取test表(字段 txt varchar2(1024))包含一条记录 txt = "D:\inetpub\wwwroot\upload\pic\hot\2011\04\14\20110414101236015.jpg"
通过.net读取到datatable后,该值变为D:\inetpub\wwwroot\upload\pic\hot\20114\14\20110414101236015.jpg
求助! --------------------编程问答-------------------- D:\inetpub\wwwroot\upload\pic\hot\2011\04\14\20110414101236015.jpg"
D:\inetpub\wwwroot\upload\pic\hot\20114\14\20110414101236015.jpg
1 插入的时候把\0替换zxc%%$1 取出的时候把zxc%%$1替换\0
或者过滤\0
/// <summary>
/// 插入SQL时替换字符
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
public static string Encode(string str)
{
str = str.Replace("'", "''");
str = str.Replace("\"", """);
str = str.Replace("<", "<");
str = str.Replace(">", ">");
str = str.Replace("\n", "<br>");
str = str.Replace("“", "“");
str = str.Replace("”", "”");
return str;
}
/// <summary>
/// 取SQL值时还原字符
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
public static string Decode(string str)
{
str = str.Replace("”", "”");
str = str.Replace("“", "“");
str = str.Replace("<br>", "\n");
str = str.Replace(">", ">");
str = str.Replace("<", "<");
str = str.Replace(""", "\"");
str = str.Replace("''", "'");
return str;
}
补充:.NET技术 , ASP.NET