blog/version-3-13-1-rc1-released/

[utterances-bot]

Version 3.13.1-rc1 released - DB Browser for SQLite

https://sqlitebrowser.org/blog/version-3-13-1-rc1-released/

[Unknown-User666]

I cannot find anywhere to download this

[chrisjlocke]

In the blog post (which you've replied to) should contain a bunch of assets.

For the avoidance of doubt, the blog post is here.
https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.13.1-rc1

So if you click that blog post (which you've replied to), do you see assets at the bottom of the page? You may need to scroll down as they're at the bottom of the page.

[justinclift]

@chrisjlocke It's a new account with almost no activity. Might just be a bot.

[thechanon]

tab "Browse Data" , render all "Date" value as "0" / Null

But Version 3.13.0 is OK

[justinclift]

@thechanon Are you able to share a database with us which has this happen for you?

Just so we can test if it happens when we try it, which will help us understand what's going wrong. 😄

[thechanon]

@justinclift Yes. may you download example file from:

https://drive.google.com/drive/folders/1_inM9fH8kf06nEiz3xqZ7_OxgDE_mzdX?usp=sharing

[justinclift]

@mgrojo Want to take a look? 😄

[chrisjlocke]

tab "Browse Data" , render all "Date" value as "0" / Null

But Version 3.13.0 is OK

Can you provide a screenshot?

Your database (https://dbhub.io/chrisjlocke2/example.db) seems OK to me.
Have you set a display format for the column? Can you provide a screenshot of what you've done?

[thechanon]

Yes. Please see capture image.

https://drive.google.com/file/d/1V_zvDYisgVkhGUBPwmnr2TKDAZYgYeLo/view?usp=sharing

Number (1) show: 2024-04-01
Number (2) show: 0

Expected : Number (2) show the same content as Number (1)

[chrisjlocke]

Well, yes, that makes sense. You've used a 'DATE' data type, which isn't a sqlite standard. SQLite only knows about text, integer, real and blobs.
https://www.sqlite.org/datatype3.html

CHAR(512) is also an unknown type.

Change it to text, and all is well again in the world. Birds continue to sing and dolphins squeak happily.

SQLite only knows about text, integer, real and blobs.

AGain, for the avoidance of doubt, this is a SQLite thing, which is the database layer, not a DB4S thing - its not like DB4S only supports certain types. So there is no fault in DB4S. Its not the applications fault. This is how SQLite works.

[chrisjlocke]

If you edit a table, DB4S handily gives you the field types it knows about

Although this is a free-type field, and you can put what you like in there, and SQLite even allows integer in text fields, text in integer fields and everything in between, the DB4S application is a bit more strict and only displays the text thingy properly for field types it knows are text fields. This is so it doesn't corrupt data. Its trying to be helpful.