<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Silly me just assumed you'd prefer integer... I'm using text codes
in my own DB designs whenever possible due to readability.<br>
<br>
In other words: of course! :-)<br>
<br>
I'll modify my code now accordingly.<br>
<br>
<br>
<div class="moz-cite-prefix">Am 15.12.2012 11:48, schrieb Mark
Webb-Johnson:<br>
</div>
<blockquote
cite="mid:3C91BB57-D70C-4A15-8A5A-893A893D2582@webb-johnson.net"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<div>The coding looks good, and sensible.</div>
<div><br>
</div>
<div>How about we just make it a text string, rather than integer.
Much clearer to read, and almost no impact on size.</div>
<div><br>
</div>
<div>VV.C.P</div>
<div><br>
</div>
<div>VV the normal vehicle types, or '*' for generic.</div>
<div>C your class</div>
<div>P your property<br>
<br>
On 15 Dec, 2012, at 6:53 AM, Michael Balzer <<a
moz-do-not-send="true" href="mailto:dexter@expeedo.de">dexter@expeedo.de</a>>
wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Mark, List,<br>
<br>
<div class="moz-cite-prefix">Am 04.12.2012 20:43, schrieb
Michael Balzer:<br>
</div>
<blockquote cite="mid:50BE5251.5080700@expeedo.de" type="cite">
<div>
<ul class="MailOutline">
<ul>
<li>type (integer type code)</li>
</ul>
</ul>
</div>
For general purpose type codes, maybe some classification
scheme would make sense? Maybe adopt some standard scheme
already defined for automotive data? ...if there is one...<br>
</blockquote>
<br>
It seems there is none suitable, so here's my attempt at
defining one. Please comment.<br>
<br>
Regards,<br>
Michael<br>
<br>
<br>
Type classification scheme:<br>
id size: 32 bit integer<br>
<br>
Generic / standard props:<br>
<br>
0x 0000 C PPP<br>
<br>
Vehicle specific props:<br>
<br>
0x VVVV C PPP<br>
<br>
VVVV = Vehicle ID<br>
0001 = Tesla Roadster<br>
0002 = Tesla Model S<br>
0003 = GM Volt / Opel Ampera<br>
0004 = Renault Twizy<br>
...<br>
<br>
C = Class:<br>
<br>
...main classes:<br>
<br>
0 = Power <br>
1 = Engine <br>
2 = Transmission <br>
3 = Chassis <br>
4 = Body <br>
5 = Electrics <br>
<br>
...auxiliary classes?<br>
<br>
6 = Safety (Chassis, Body, Electrics)<br>
7 = Security (Power?, Body, Electrics)<br>
8 = Comfort (Chassis, Body, Electrics)<br>
9 = Entertainment (Body, Electrics)<br>
a = Communication (Body, Electrics)<br>
<br>
<br>
b = reserved<br>
c = reserved<br>
d = reserved<br>
e = reserved<br>
f = reserved<br>
<br>
<br>
PPP = Property<br>
...allowing for 4096 properties per class.<br>
<br>
<br>
<br>
<br>
<pre class="moz-signature" cols="72">--
Michael Balzer * Paradestr. 8 * D-42107 Wuppertal
Fon 0202 / 272 2201 * Handy 0176 / 206 989 26
</pre>
</div>
</blockquote>
<blockquote type="cite">
<div><dexter.vcf></div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>OvmsDev mailing list</span><br>
<span><a moz-do-not-send="true"
href="mailto:OvmsDev@lists.teslaclub.hk">OvmsDev@lists.teslaclub.hk</a></span><br>
<span><a moz-do-not-send="true"
href="http://lists.teslaclub.hk/mailman/listinfo/ovmsdev">http://lists.teslaclub.hk/mailman/listinfo/ovmsdev</a></span><br>
</div>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
OvmsDev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:OvmsDev@lists.teslaclub.hk">OvmsDev@lists.teslaclub.hk</a>
<a class="moz-txt-link-freetext" href="http://lists.teslaclub.hk/mailman/listinfo/ovmsdev">http://lists.teslaclub.hk/mailman/listinfo/ovmsdev</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Michael Balzer * Paradestr. 8 * D-42107 Wuppertal
Fon 0202 / 272 2201 * Handy 0176 / 206 989 26
</pre>
</body>
</html>