Such problem (strip of NEWLINE) appears in versions 7.3.0.30, 7.3.0.28 of ODBC driver for Windows (w2000 sp3) platforms.
My application was create on Visual C++ 6.0 with MFC lib. Code for insert is
very simple:
strDSN1.Format("DSN=%s;UID=%s;PWD=%s",strDSN,p_UserInfo.strLogin,p_UserInfo.
strPassword);
m_db.OpenEx(strDSN1,NULL);
strSQL.Format("insert into user_todo
id,id_user,r_date,todo,id_color,bcheck,id_icon,id_period,id_importance,bfini
sh,bdel,id_type) values ( 57, 93, '2003-03-03 13:57:00.000000',
'1212\n1212\n11212\n121212', 16777215, 0, 99, 0, 0, 0, 0, 1)");
m_db.ExecuteSQL(strSQL);
Trace of ODBC for both versions of ODBC drivers in attachment.
So, then I execute select query and I have not found "new line" in result
string. In version 7.3.0.21 of ODBC driver I have NO such problems .
Possible expect fixed driver version 7.3.0.30 in the near future?
Pavel Konovalov
________________________________
JS RCOM, Russia
http://www.rscom.ru
sqltrace_73021.pct
Description: Binary data
sqltrace_73030.pct
Description: Binary data
