D 2018-09-02T17:51:20.586
J icomment I'm\sable\sto\sreproduce\sthe\sexception\shere.\s\sThe\sroot\scause\sof\sthis\sissue\sis\sthat\r\nthe\sSQLite\score\slibrary\sreturns\s'integer'\saffinity\sfor\sthe\ssecond\svalue,\spartly\r\ndue\sto\sits\snot\sconsidering\sthe\sdeclared\scolumn\stype\s('String')\sto\shave\stextual\r\naffinity.\r\n\r\nEverything\sappears\sto\sbe\sworking\sas\sdesigned.\s\sThere\sare\stwo\spotential\ssolutions\r\nto\sthis\sissue:\r\n\r\n1.\sChange\sthe\scolumn\stype\sto\sbe\s'TEXT'\sinstead\sof\s'String',\swhich\sshould\scause\r\n\s\s\sthe\sSQLite\score\slibrary\sto\sreturn\s'TEXT'\saffinity\sfor\sthe\scolumn\svalue,\seven\r\n\s\s\sif\sit\slooks\slike\san\sinteger.\r\n\r\n2.\sUse\sthe\sconnection\sflag\s'NoVerifyTextAffinity',\swhich\swill\sprevent\sexceptions\r\n\s\s\sfrom\sbeing\sthrown\sby\sthe\sSystem.Data.SQLite\stype\sconversion\ssubsystem.\r\n\r\nThe\s#1\ssolution\sis\spreferred\sin\sthis\scase,\sif\spossible,\sbecause\sit\sreduces\r\nthe\samount\sof\sunnecessary\stype\sconversion\swork\sperformed\sby\sthe\sSQLite\score\r\nlibrary\sand\sthe\sSystem.Data.SQLite\scode.
J login mistachkin
J mimetype text/x-fossil-plain
J resolution Works_As_Designed
J status Pending
K 458738515e70f99f0ce997894c9602bfce9cb2ed
U mistachkin
Z fd6704d7691f3923a050c1be4062cac6