<div dir="ltr">It could be a set character problem, with which operating system and/or distro did you create the database, did the system use UTF-8?<br>See here:<br><a href="http://gambaswiki.org/wiki/lang/conv" target="_blank">http://gambaswiki.org/wiki/lang/conv</a><br><div>I would advise you to export the data to csv and import them into a new database with Gambas using Conv$.</div><div><br></div><div>Regards</div><div>Gianluigi<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mar 26 nov 2019 alle ore 09:18 David Silverwood via User <<a href="mailto:user@lists.gambas-basic.org" target="_blank">user@lists.gambas-basic.org</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:13px"><div></div>
<div dir="ltr">HI Gianluigi</div><div dir="ltr">Lee's statement was directed at me using a textbox for dates. It actually works for me except when I try and retrieve a date from the SQLite database. </div><div dir="ltr">I'm beginning to suspect that if I do not create the DB in Gambas then it is difficult to get it to work. My current database is ten years old and has 200k entries +. I originally created it in xbasic in 2008/2009 and even after using a datebox Gambas still doesn't read the date properly. However, if I create a new DB in Gambas and do all these things it works without a hitch. </div><div dir="ltr">It doesn't make sense to me though since the date portion of the database in sqlite3 is still DATE and referred to as such in the DB. When I create the new DB using Gambas it just works, whether I load or retrieve, but when I go to my old DB then all the dates go awry. I'm definitely going to need some time to work through this.</div><div dir="ltr">Thanks for that datadate source. It's helped a lot, AND also for helping me get the datebox back. Much appreciated.</div><div><br></div>
</div><div id="gmail-m_4231677867875803995gmail-m_2236624692987634346yahoo_quoted_5561525611">
<div style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
<div>
On Monday, November 25, 2019, 06:31:08 PM GMT+2, Gianluigi <<a href="mailto:bagonergi@gmail.com" target="_blank">bagonergi@gmail.com</a>> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="gmail-m_4231677867875803995gmail-m_2236624692987634346yiv2897492246"><div><div dir="ltr"><div dir="ltr"><br clear="none"></div><br clear="none"><div><div id="gmail-m_4231677867875803995gmail-m_2236624692987634346yiv2897492246yqtfd60049"><div dir="ltr">Il giorno lun 25 nov 2019 alle ore 16:30 T Lee Davidson <<a rel="nofollow" shape="rect" href="mailto:t.lee.davidson@gmail.com" target="_blank">t.lee.davidson@gmail.com</a>> ha scritto:<br clear="none"></div></div><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div id="gmail-m_4231677867875803995gmail-m_2236624692987634346yiv2897492246yqtfd96707">SQLite can store dates as one of three different types: text, real, or integer.<br clear="none">
<br clear="none">
<a rel="nofollow" shape="rect" href="https://www.sqlite.org/datatype3.html" target="_blank">https://www.sqlite.org/datatype3.html</a><br clear="none">
<br clear="none">
<br clear="none">
___<br clear="none">
Lee</div><br clear="none">
<br clear="none"></blockquote><div><br clear="none"></div><div><br clear="none"></div><div>I refer to Gambas not to SQLite.<br clear="none">See what Benoit says about it:<br clear="none"><a rel="nofollow" shape="rect" href="http://gambaswiki.org/wiki/doc/date" target="_blank">http://gambaswiki.org/wiki/doc/date</a><br clear="none">See also:<br clear="none"><a rel="nofollow" shape="rect" href="http://gambaswiki.org/wiki/doc/db-type-mapping" target="_blank">http://gambaswiki.org/wiki/doc/db-type-mapping</a><br clear="none"><br clear="none">Regards<br clear="none">Gianluigi <div id="gmail-m_4231677867875803995gmail-m_2236624692987634346yiv2897492246yqtfd99455"><br clear="none"></div></div></div></div></div></div><div id="gmail-m_4231677867875803995gmail-m_2236624692987634346yqtfd87391"><br clear="none">----[ Gambas mailing-list is hosted by <a shape="rect" href="https://www.hostsharing.net" target="_blank">https://www.hostsharing.net </a>]----<br clear="none"></div></div>
</div>
</div></div><br>
----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
</blockquote></div>