TSqlite3DataSet save boolean value as 0/1 while Zeos save as 'Y' 'N'
lazarus / 16-Databases

----------------------------------------------------------------------
Goodman H__ · 2010-09-08 01:32

Greetings!

Just found this,due to the Chinese font issue,I tested database
programming by TSqlite3Dataset,TDatabaseConnection sets,and Zeos.

I found in a sqlite3 manager tool,those records created by
TSqlite3DataSet and by Zeos show differerent on boolean
field.TSqlite3DataSet shows 0 and 1 but Zeos show 'Y' and 'N'.

PS,under my installation,one is under XP and another is under
Win7,Zeos can treat date field properly but TSqlite3DataSet can't.With
the date format matches system locale settings,TSqlite3DataSet will
show blank with date field.

Regards,

----------------------------------------------------------------------
LuizAmérico · 2010-09-08 10:11

See http://sqlite4fpc.yolasite.com/faq.php (Q2)

----------------------------------------------------------------------
stonefull · 2010-09-08 14:46

See too http://www.sqlite.org/datatype3.html

----------------------------------------------------------------------
jixian.yang · 2010-09-09 02:50

The boolean value should be 1 or 0 in program.

for date format:
insert into tdatatime (ddatetime) values ('2004-05-23T14:25:10')
insert into tdata (ddate) values ('2004-05-23')


Here is a patch for Chinese font:
http://bugs.freepascal.org/view.php?id=17376

----------------------------------------------------------------------
Goodman H__ · 2010-09-12 10:14

Quote from: jixian.yang on September 09, 2010, 04:50:16 amThe boolean
value should be 1 or 0 in program.

for date format:
insert into tdatatime (ddatetime) values ('2004-05-23T14:25:10')
insert into tdata (ddate) values ('2004-05-23')


Here is a patch for Chinese font:
http://bugs.freepascal.org/view.php?id=17376

Sorry for my stupid.How to install the patch?

----------------------------------------------------------------------
JuhaManninen · 2010-09-12 14:24

Quote from: Goodman H__ on September 12, 2010, 12:14:32 pmSorry for my
stupid.How to install the patch?

http://wiki.lazarus.freepascal.org/Creating_A_Patch#Applying_a_patch

although in this case you can as well type the 2 characters into the
code.

Juha

----------------------------------------------------------------------
jixian.yang · 2010-09-15 13:55

In this patch, just set field size to triple.

There should be a better solution.

----------------------------------------------------------------------
Goodman H__ · 2010-09-28 01:30

Quote from: jixian.yang on September 15, 2010, 03:55:52 pmIn this
patch, just set field size to triple.

There should be a better solution.


Thanks.Then how about TOdbcConnection,is there a similar solution to
temp. fix it?

----------------------------------------------------------------------
Goodman H__ · 2011-05-04 09:18

Quote from: Goodman H__ on September 28, 2010, 03:30:11 amQuote from:
jixian.yang on September 15, 2010, 03:55:52 pmIn this patch, just set
field size to triple.

There should be a better solution.


Thanks.Then how about TOdbcConnection,is there a similar solution to
temp. fix it?

Just want to know is this issue fixed in the newest version of fp and
Laz,or any known solutioni at present.That is,fields value contain
asia language can not show properly in TOdbcConnection series
components.

Regards,
Sam

----------------------------------------------------------------------
Lacak2 · 2011-05-04 10:39

AFAIK there are no news in this