Anil Mujagić anilmujagic
anilmujagic
/ SQLiteDecimalRoundTrip.sql
Created
November 22, 2019 12:22
SQLite losing decimals on DB round trip
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE item (amount NUMERIC(18, 7) NOT NULL); | |
| INSERT INTO item VALUES (12345678901.1234567); | |
| SELECT * FROM item; -- 12345678901.1235 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <span style="font-family: Monaco, Consolas, 'Courier New', Courier, monospace; font-weight: bold; font-size: xx-large;">F# |> I <span style="color: red;">❤</span></span> |
anilmujagic
/ gist:5173812
Created
March 15, 2013 22:57
Serializing Exception to JSON using Json.NET and ServiceStack.Text
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| static void Main(string[] args) | |
| { | |
| try | |
| { | |
| var x = 1 / args.Length; | |
| } | |
| catch (Exception ex) | |
| { | |
| Console.WriteLine(Newtonsoft.Json.JsonConvert.SerializeObject(ex)); | |
| Console.WriteLine(); |