D 2019-06-12T14:12:25.058
J icomment I\sthink\sthat\swhat\s"lossless"\smean\sin\sthis\scontext\sis\sup\sto\sinterpretation.\sIn\ssome\ssense,\sall\sconversions\sare\slossful.\sFor\sexample,\sboth\s'1.0'\sand\s'1'\sare\sconverted\sto\s1\sand\sit\sis\snot\spossible\sto\sdetermine\swhether\sthe\soriginal\sstring\swas\s'1.0'\sor\s'1'.\r\n\r\n<pre>\r\nSELECT\sCAST('1.0'\sAS\sNUMERIC);\s--\s1\r\nSELECT\sCAST('1'\sAS\sNUMERIC);\s--\s1\r\n</pre>
J login mrigger
J mimetype text/x-fossil-wiki
K 674385aeba91c774d47736f1aefd259b074dc5d3
U mrigger
Z bda16cf6e1a87ab374b354b783391e24