[yunqa.de] DISQLITE cant UPDATE to TEXT to "password"

  • From: "spamyard" <spamyard@xxxxxx>
  • To: <yunqa@xxxxxxxxxxxxx>
  • Date: Mon, 4 Aug 2008 11:30:31 +0300

Following bug cant Update data to string “password”

 

CREATE TABLE "IODevices" ("ID" INTEGER PRIMARY KEY, 

 "Name" TEXT, "Type" INTEGER, 

 "OptionsInt" INTEGER, "OptionsStr" TEXT,

 "UserName" TEXT,"Password" TEXT,

 "HostAddr" TEXT, "SendTo" TEXT, "SentFrom" TEXT,

 "RetryDelay1" INTEGER, "RetryDelay2" INTEGER);

 

UPDATE IODevices SET "Name" = "password" WHERE ID = 4;

this sets „Name” to „passwor”

 

UPDATE IODevices SET "Name" = "passwors" WHERE ID = 4;

this sets „Name” to „passwors”

 

UPDATE IODevices SET "Name" = ‘password’ WHERE ID = 4;

this sets „Name” to „password”

 

Other related posts: