--- a/persistentstorage/sql/TEST/t_sqldefect2.cpp	Wed Sep 15 14:05:58 2010 +0300
+++ b/persistentstorage/sql/TEST/t_sqldefect2.cpp	Wed Oct 13 16:30:44 2010 +0300
@@ -416,93 +416,6 @@
     TEST2(err, KErrAlreadyExists);
     }
 
-/**
-@SYMTestCaseID          PDS-SQL-CT-4213
-@SYMTestCaseDesc        Tests the ability of the SQL server to store empty strings and retrieve them as 
-						text column values, not NULLs.
-						Change: ou1cimx1#504388. 
-@SYMTestPriority        High
-@SYMTestActions         The test creates a database and a table and stores there empty strings.
-						Then the test retrieves the stored column values and verifies that the column type is
-						"text", not "null".
-@SYMTestExpectedResults Test must not fail
-*/
-void EmptyTextColumnTest()
-	{
-	_LIT8(KEncUtf16, "encoding=\"UTF-16\"");
-	_LIT8(KEncUtf8, "encoding=\"UTF-8\"");
-	TPtrC8 enc[] = {KEncUtf16(), KEncUtf8()};
-	for(TInt i=0;i<(sizeof(enc)/sizeof(enc[0]));++i)
-		{
-		(void)RSqlDatabase::Delete(KTestDatabase1);
-		TInt err = TheDb1.Create(KTestDatabase1, &enc[i]);
-		TEST2(err, KErrNone);
-		//Insert records with empty text column values using RSqlDatabase::Exec()
-	    err = TheDb1.Exec(_L("CREATE TABLE A(ID INTEGER, T TEXT)"));
-	    TEST(err >= 0);
-	    err = TheDb1.Exec(_L("INSERT INTO A VALUES(1, '')"));
-	    TEST2(err, 1);
-	    err = TheDb1.Exec(_L8("INSERT INTO A VALUES(2, '')"));
-	    TEST2(err, 1);
-		//Insert a record with empty text column value using RSqlParamWriteStream
-	    RSqlStatement stmt;
-	    err = stmt.Prepare(TheDb1, _L("INSERT INTO A(ID, T) VALUES(:P1, :P2)"));
-	    TEST2(err, KErrNone);
-		err = stmt.BindInt(0, 3);
-	    TEST2(err, KErrNone);
-	    RSqlParamWriteStream strm;
-	    err = strm.BindText(stmt, 1);
-	    TEST2(err, KErrNone);
-	    TRAP(err, strm.WriteL(KNullDesC));
-	    TEST2(err, KErrNone);
-	    strm.Close();
-	    err = stmt.Exec();
-	    TEST2(err, 1);
-	    stmt.Close();
-		//Insert records with empty text column values using RSqlStatement::Bind()
-	    err = stmt.Prepare(TheDb1, _L("INSERT INTO A(ID, T) VALUES(:P1, :P2)"));
-	    TEST2(err, KErrNone);
-		err = stmt.BindInt(0, 4);
-	    TEST2(err, KErrNone);
-		err = stmt.BindText(1, KNullDesC);
-	    TEST2(err, KErrNone);
-	    err = stmt.Exec();
-	    TEST2(err, 1);
-	    //
-	    err = stmt.Reset();
-	    TEST2(err, KErrNone);
-		err = stmt.BindInt(0, 5);
-	    TEST2(err, KErrNone);
-	    _LIT(KEmptyStr, "");
-		err = stmt.BindText(1, KEmptyStr);
-	    TEST2(err, KErrNone);
-	    err = stmt.Exec();
-	    TEST2(err, 1);
-	    stmt.Close();
-	    //Read the empty text column values
-	    err = stmt.Prepare(TheDb1, _L("SELECT T FROM A"));
-	    TEST2(err, KErrNone);
-	    TInt cnt = 0;
-	    while((err = stmt.Next()) == KSqlAtRow)
-	    	{
-			++cnt;
-			TPtrC val;
-			err = stmt.ColumnText(0, val);
-			TEST2(err, KErrNone);
-			TEST2(val.Length(), 0);
-			TSqlColumnType type = stmt.ColumnType(0);
-			TEST2(type, ESqlText);
-	    	}
-	    stmt.Close();
-	    TEST2(err, KSqlAtEnd);
-	    TEST2(cnt, 5);
-	    //
-	    TheDb1.Close();
-	    err = RSqlDatabase::Delete(KTestDatabase1);
-	    TEST2(err, KErrNone);
-		}
-	}
-
 void DoTestsL()
 	{
 	TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4154 DEF143062: SQL, \"CREATE INDEX\" sql crashes SQL server"));
@@ -520,9 +433,6 @@
     TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4211 Temp files created during sql operations are not deleted after rebooting the phone - 2"));
     TempFileTest();
     
-    TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-CT-4213 No support to store an empty string in symbian's sqlite."));
-    EmptyTextColumnTest();
-
     TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4214 After *#7370# Java apps are not preinstalled again"));
     DeleteTempFolder();
 	}