Is there any way to input into a boolean field in the Pycharm database window?

user_2558739 0
Viewed 217

I'm trying to type a row of data into the Pycharm database window. My DB is SQLite. However, I can't find a way to type a value into a boolean column (in the case below it's the current_record_fg column).

enter image description here

Is there any way for me to type a value into that boolean field? (I've tried right clicking, etc. Nothing seems to work). Thanks!

pycharm
1 Answers

You can't edit these in the PyCharm Database tools, but SQLite Studio make this an easy process. You can copy paste from excel (or any other tab delineated format). Remember that in SQLite Boolean data is stored as a 0 for false and 1 for true. Official site: https://sqlitestudio.pl/

user_20332520
Related