Recent changes to 49: Additional quotes for default values for text fieldshttps://sourceforge.net/p/sqlitemanager/bugs/49/2010-08-10T11:34:36ZRecent changes to 49: Additional quotes for default values for text fieldsAdditional quotes for default values for text fields2010-08-10T11:34:36Z2010-08-10T11:34:36ZSergey Verlanhttps://sourceforge.net/u/sverlan/https://sourceforge.net2cd3df1c3083e4b8b8f84aed4d3fdf771e56d33c<div class="markdown_content"><p>If a default value for a text (string) field is given, then when modifying the table/field, additional quotes are added around the value. The same holds if a record is inserted.</p>
<p>Example:<br />
The table: <br />
CREATE TABLE 't2' ( 'id' INTEGER NOT NULL PRIMARY KEY, 'name' TEXT NOT NULL DEFAULT '""', 'info' TEXT NOT NULL DEFAULT 'simple info' );</p>
<p>When modifying any field additional quotes are inserted around the default value. When inserting - the value has quotes, while it shouldn't.</p>
<p>Temporary fix (file common.lib.php): </p>
<p>434c434<br />
< if($info['dflt_value']!= '') $data = $info['dflt_value'];<br />
---<br />
> if($info['dflt_value']!= '') $data = unquote($info['dflt_value']);<br />
450d449<br />
< </p></div>