## Integer data type mapping problem with SQLInsert in DatabaseLink package

1

1

I am working with a following SQL table named "ticket". Now let's see the data types for the columns.

SQLColumns[conn,"ticket"]/.SQLColumn[{"ticket",a_},"DataTypeName"->b_,
"DataLength"->c_,"Default"->__,"Nullable"->__]:> a-> {b,c}


{"end_time_stamp" -> {"int8", 19}, "kms" -> {"varchar", 255}}

Now when I use SQLInsert to enter the values in the columns I get no error.

SQLInsert[conn, "ticket", {"end_time_stamp", "kms"}, {20161102135641,"273-A"}]


However fetching the data from table shows wrong integer was inserted.

SQLSelect[conn, "ticket", "end_time_stamp", SQLColumn["kms"] =="273-A"]


{535656579}

where as we should get the integer 20161102135641 back. I have loaded the database driver using JDBCDrivers["PostgreSQL"].
{"extraction_info": {"found_math": true, "script_math_tex": 0, "script_math_asciimath": 0, "math_annotations": 0, "math_alttext": 0, "mathml": 0, "mathjax_tag": 0, "mathjax_inline_tex": 0, "mathjax_display_tex": 0, "mathjax_asciimath": 1, "img_math": 0, "codecogs_latex": 0, "wp_latex": 0, "mimetex.cgi": 0, "/images/math/codecogs": 0, "mathtex.cgi": 0, "katex": 0, "math-container": 0, "wp-katex-eq": 0, "align": 0, "equation": 0, "x-ck12": 0, "texerror": 0, "math_score": 0.31964510679244995, "perplexity": 19342.48875086915}, "config": {"markdown_headings": true, "markdown_code": true, "boilerplate_config": {"ratio_threshold": 0.18, "absolute_threshold": 10, "end_threshold": 15, "enable": true}, "remove_buttons": true, "remove_image_figures": true, "remove_link_clusters": true, "table_config": {"min_rows": 2, "min_cols": 3, "format": "plain"}, "remove_chinese": true, "remove_edit_buttons": true, "extract_latex": true}, "warc_path": "s3://commoncrawl/crawl-data/CC-MAIN-2021-31/segments/1627046154310.16/warc/CC-MAIN-20210802075003-20210802105003-00029.warc.gz"}