alex19860224 2015-09-11 02:19
浏览 3621

关于连接oracle数据库中OleDbConnection和OracleConnection的问题

当前碰到一个问题,数据库中字段的类型是nvarchar2
程序用OleDbConnection方式连接后用传参方式更新字段内容
using (OleDbConnection conn = new OleDbConnection())
{
conn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=sima;User ID=vas;Password=vas;min pool size=1;max pool size=100";
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "UPDATE ROA_CFG_SMS SET CONTENT = :content WHERE ID = 10";
cmd.Parameters.Add(":content", OleDbType.VarChar);
cmd.Parameters[0].Value = ”àâçéèêëîïôœùûÀÂÇÉÈÊËÎÏÔŒÙÛn°€…“;
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();

            object name;
            cmd.CommandText = "SELECT CONTENT FROM ROA_CFG_SMS WHERE ID = 10";
            name = cmd.ExecuteScalar();
            textBox2.Text = name.ToString();
        }

程序用OracleConnection方式连接后用传参方式更新字段内容
using (OracleConnection conn = new OracleConnection())
{
conn.ConnectionString = "Data source=sima;User ID=vas;Pwd=vas";
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "UPDATE ROA_CFG_SMS SET CONTENT = :content WHERE ID = 10";
cmd.Parameters.Add(":content", OracleType.NVarChar);
cmd.Parameters[0].Value = "àâçéèêëîïôœùûÀÂÇÉÈÊËÎÏÔŒÙÛn°€…";
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();

            object name;
            cmd.CommandText = "SELECT CONTENT FROM ROA_CFG_SMS WHERE ID = 10";
            name = cmd.ExecuteScalar();
            textBox2.Text = name.ToString();
        }

用OleDbConnection方式更新会出现乱码,用OracleConnection方式则正常,当前需要用OleDbConnection方式连接,请问应该怎么解决这个乱码问题呢?

  • 写回答

0条回答

    报告相同问题?

    悬赏问题

    • ¥15 identifier of an instance of 类 was altered from xx to xx错误
    • ¥100 反编译微信小游戏求指导
    • ¥15 docker模式webrtc-streamer 无法播放公网rtsp
    • ¥15 学不会递归,理解不了汉诺塔参数变化
    • ¥15 基于图神经网络的COVID-19药物筛选研究
    • ¥30 软件自定义无线电该怎样使用
    • ¥15 R语言mediation包做中介分析,直接效应和间接效应都很小,为什么?
    • ¥15 Jenkins+k8s部署slave节点offline
    • ¥15 如何实现从tello无人机上获取实时传输的视频流,然后将获取的视频通过yolov5进行检测
    • ¥15 WPF使用Canvas绘制矢量图问题