From: Thomas <ja...@ma...> - 2003-11-19 22:50:30
|
When I insert this string: string t =3D "@123"; in my database,=20 only a "?" is appear in the database. When I retrive the value, I altso get a "?". Why are the "@" convertet to a "?"...... And why are everything after the "@" erased...... This problem only arise when I use Beta4 (v. 1.5.1410.16587). When I use beta2 (1.5.1356.23155) the whole string is insertet correct = in the database ("@123"). My code: ....... string t =3D "@123";=20 FB.insert("INSERT INTO TABLE1 (COL1) VALUES ( " + "'" + t + "'" + ")"); ...... ......... private string myConnectionString =3D "Database=3D" + "c:\\TEST.GDB" + = ";User=3D" + "SYSDBA" + ";Password=3D" + "masterkey" + ";Dialect=3D" + 1 = + ";Charset=3D" + "NONE" + ";Server=3D" + "localhost"; ............... .......... public bool insert(string myInsertQuery) { try { transaction =3D myConnection.BeginTransaction(); myCommandOne =3D new FbCommand(myInsertQuery, myConnection, = transaction);=20 myCommandOne.ExecuteNonQuery(); transaction.Commit(); myCommandOne.Dispose();=20 } catch(Exception ea) { ea =3D ea; throw new Exception(ea.Message); }//try/catch return true; } ..................... my table: CREATE TABLE TABLE1 ( COL1 VARCHAR( 55) ); I use: WinXP PRO SP1 .NET 1.1 Firebird-1.5.0.4027-RC7 as SuperServer Regards Thomas |