前台的Memo1中内容:
aaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbb
ccccccccc
ddddddddddddddd
存入数据库(ORACLE字段varchar2)后再前台显示,结果变成了
aaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbcccccccccddddddddddddddd
aaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbb
ccccccccc
ddddddddddddddd
存入数据库(ORACLE字段varchar2)后再前台显示,结果变成了
aaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbcccccccccddddddddddddddd
如果查询时用memo组件应该不会有问题吧
Query1.Close;
Query1.SQL.Clear ;
Query1.SQL.ADD('Insert into WEEKPLAN');
Query1.SQL.ADD('VALUES(TO_DATE('''+YEARMONTH+''',''YYYY-MM''),'''+Trim(Combobox6.Text)+''',TO_DATE('''+FormatDateTime('YYYY-MM',DateTimePicker5.Date)+''',''YYYY-MM''),'''+Trim(Edit3.text)+''','''+Memo4.text+''' )');
Query1.EXECSQL;
改成如下,一切正常
Query1.Close;
Query1.SQL.Clear ;
Query1.SQL.ADD('Insert into WEEKPLAN');
Query1.SQL.ADD('VALUES(TO_DATE('''+YEARMONTH+''',''YYYY-MM''),'''+Trim(Combobox6.Text)+''',TO_DATE('''+FormatDateTime('YYYY-MM',DateTimePicker5.Date)+''',''YYYY-MM''),'''+Trim(Edit3.text)+''',:T )');
Query1.Params[0].AsString := Memo4.Text;
Query1.EXECSQL;