NULL characters and sorting
support at ahsomme.com
Fri Mar 20 12:29:16 CDT 2009
Thank you Jim and Bob.
On Mar 20, 2009, at 9:35 AM, Bob Sneidar wrote:
> Also, I have a rule when designing SQL databases: NO NULLS! I
> always use empty strings as the default value for a text field and
> 0 as the default for number fields.
> Bob Sneidar
> IT Manager
> Logos Management
> Calvary Chapel CM
> On Mar 20, 2009, at 9:27 AM, Jim Ault wrote:
>> When using the filter command and foreign data I always replace null
>> with empty (or space, depending). Hypercard used '00' to be the end
>> char of strings in its stack structure. In the days of recovering
>> from hard drive corruption, I did many scans in hex for stack data
>> Some systems will add a null to web pages and since they are ignored
>> by browsers, no worries until you capture and try to work with the
>> Jim Ault
>> Las Vegas
>> On Mar 20, 2009, at 8:42 AM, Paul Looney wrote:
>>> Thanks for the insight.
>>> Most of this archived data had been imported from the previous
>>> HyperCard system. We've now done many such imports and this is the
>>> only customer with this problem.
>>> Another customer, at the other end of the country, had a different
>>> problem; blank spaces in fields. For example, the description field
>>> might have 25 lines; lines 1 to 4 were correct, lines 5 to 9 were
>>> missing, and lines 10 to 25 were correct. The "hole" was not always
>>> in the same fields or the same lines. We traced this back to them
>>> using AppleWorks and MS Word to write notes - which they had then
>>> pasted into the notes field on the HC-based program.
>>> We occasionally get a NULL in the current, Rev-based, system (about
>>> one in six months). We have checked the code but not found a source.
>>> Obviously the user can not type a NULL.
>>> I will vote for both 7823 and, especially 7824.
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode