Re: [Openinteract-dev] anyone knowledgable about cross-platform datatypes?

[Chris W. <ch...@cw...>]

Andrew Hurst wrote:
>> So my question is: is there any consistent column type for this, or do 
>> I need to make this vary among database vendors as well?
> 
> I haven't looked into it too much, but to add one more data point to the 
> list, Oracle uses 'date' columns which store the date and the time.  I 
> would expect you need to make this vary among the vendors, and have 

Yeah, I was afraid of this. Thanks for the Oracle note.

I'll probably make this change in the next release.

> special cases for it.  What might be worse is the date/time formatting, 
> I doubt that it's standardized.

Date/time formatting is *MUCH* worse, but fortunately that can be 
dealt with almost entirely within the application logic. Someone 
else's problem :-)

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.