数据转义符问题

[sqlaqandy]

从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;
        }