Search found 7 matches

by igitur
09.10.2008, 08:01
Forum: SQLite Administrator
Topic: Boolean fields: 1/0 vs Y/N
Replies: 7
Views: 2379

Administrator, am I to understand from http://zeos.firmos.at/viewtopic.php?t=1 ... 3ec9c24a15 that you will NOT fix this?
by igitur
09.10.2008, 07:57
Forum: SQLite Administrator
Topic: Boolean fields: 1/0 vs Y/N
Replies: 7
Views: 2379

The Y/N also causes problems in other Sqlite GUIs, like SQLite2008 Pro, that don't recognise the Y/N as valid BOOLEAN fields.

Really guys... 1/0 is the standard.
by igitur
06.10.2008, 10:07
Forum: SQLite Administrator
Topic: Boolean fields: 1/0 vs Y/N
Replies: 7
Views: 2379

I'd love to hear the developer's comments on this issue...
by igitur
03.09.2008, 13:01
Forum: SQLite Administrator
Topic: Boolean fields: 1/0 vs Y/N
Replies: 7
Views: 2379

Are you sure that both the ways are supported? Somewhere I used one, somewhere the second... Yes I'm quite sure. At the moment I have a table with a boolean field. Half of the entries are from an import that I did from a CSV file. These entries' boolean fields are either 1 or 0. The other entries w...
by igitur
01.09.2008, 16:37
Forum: SQLite Administrator
Topic: Boolean fields: 1/0 vs Y/N
Replies: 7
Views: 2379

Boolean fields: 1/0 vs Y/N

Hi, When editing table data by using the Edit Data tab, checking / unchecking checkboxes for boolean fields enters Y or N in the fields. I understand that Sqlite is weakly typed and that using Y/N as opposed to 1/0 is a personal choice, but I really feel that 1/0 is a better option. Almost all the o...
by igitur
29.05.2007, 15:22
Forum: SQLite Administrator
Topic: Automapping CSV import fields
Replies: 0
Views: 1945

Automapping CSV import fields

Hi, This would require some work, but I often have to import a CSV file where the column headers are identical to the destination table's field names. It often is about 30 columns, so I have to go through the tedious process of mapping the source column to the destination column, even though the nam...
by igitur
30.04.2007, 14:06
Forum: SQLite Administrator
Topic: Default Sqlite database version
Replies: 1
Views: 2023

Default Sqlite database version

When creating a new Sqlite database, I suggest that you make version 3 the default version. Currently version 2 is selected by default.

regards,
igitur