Re: Stashing 3 or 4 characters into a text for db storage

2012-07-21 Thread Dr. Hawkins
On Sat, Jul 21, 2012 at 10:59 AM, wrote: > Not sure I understand what you want, but are you married to having a single > numeric > string encode your three/four char data? no, just trying to be efficient--an integer has four bytes, which invites me to use it :_) > It would be so much easier to

Re: Stashing 3 or 4 characters into a text for db storage

2012-07-21 Thread dunbarx
Newman -Original Message- From: Dr. Hawkins To: How to use LiveCode Sent: Sat, Jul 21, 2012 12:24 pm Subject: Stashing 3 or 4 characters into a text for db storage As I'm adjusting my data to get ready for postgreSQL instead of SQLite, I've pretty much settled on having two, r

Stashing 3 or 4 characters into a text for db storage

2012-07-21 Thread Dr. Hawkins
As I'm adjusting my data to get ready for postgreSQL instead of SQLite, I've pretty much settled on having two, rather than one, data tables. Dollar amounts and other simple things will go into one table, while text will go into another with a VACHAR type. I have various calculated properties th