Re: Storing dates

From	Thomas 'PointedEars' Lahn <PointedEars@web.de>
Newsgroups	comp.databases, comp.databases.mysql, comp.lang.php
Subject	Re: Storing dates
Followup-To	comp.databases
Date	2014-06-22 14:59 +0200
Organization	PointedEars Software (PES)
Message-ID	<2639518.R2M4nku0sZ@PointedEars.de> (permalink)
References	(6 earlier) <XnsA3538B556C72Bdougmilmaccom@78.46.70.116> <hzk4wa449wa$.3xtj0jkxz78o$.dlg@40tude.net> <XnsA353998B95688dougmilmaccom@78.46.70.116> <210620142206250710%timstreater@greenbee.net> <d3ubq91a9ufstpi1fp963r54684sue6cr9@4ax.com>

Cross-posted to 3 groups.

Followups directed to: comp.databases

Show all headers | View raw

[F'up2 comp.databases]

J�rgen Exner wrote in comp.databases.mysql and comp.lang.php:
^^^^^^^^^^^^
Please do not use non-ASCII characters (like umlauts) in header field 
values unless you are prepared to properly MIME-encode them as RFC 5322, and 
by reference RFC 5536, requires it.  Forté Agent is not smart enough for 
that, at least not the outdated version of it that you are using.

> On Sat, 21 Jun 2014 22:06:25 +0100, Tim Streater
> <timstreater@greenbee.net> wrote in comp.databases.mysql:

It's attribution *line*, _not_ attribution novel.

>> I have a field which contains values like 3.7, 4.2, etc. But when I
>> defined the field (in SQLite) I made it a TEXT field, forgetting that I
>> would need to be able to sort on that field.
>>
>> My workaround is to convert the string to floating at the time of the
>> sort. In SQLite I do:
>>
>>  ... ORDER BY ROUND(myfield,1);
>>
>> which works just fine.

By coincidence.

> Yes, that is a very well-known workaround commonly known as casting.

In this case the value is cast to an IEEE-754 double, probably resulting in 
different values.

<http://www.sqlite.org/faq.html#q16>


PointedEars
-- 
Sometimes, what you learn is wrong. If those wrong ideas are close to the 
root of the knowledge tree you build on a particular subject, pruning the 
bad branches can sometimes cause the whole tree to collapse.
  -- Mike Duffy in cljs, <news:Xns9FB6521286DB8invalidcom@94.75.214.39>

Back to comp.databases | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-22 14:59 +0200
  Re: Storing dates Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-22 09:27 -0400
    Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-22 22:20 +0200
    Re: Storing dates Jasen Betts <jasen@xnet.co.nz> - 2014-06-23 06:01 +0000
  Re: Storing dates Tim Streater <timstreater@greenbee.net> - 2014-06-22 16:11 +0100
    Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-22 22:42 +0200

csiph-web