Wednesday, July 18, 2007

JSON and Oracle: who saide javascript is not typed?!

For oracle, you only use four types: varchar2, number, char (because of the padding, it should only be used for "Y" and "N"), and date

JSON make it shorter: string (with""), number (no ""), false and true, no date!

For date, M$ has a cleaver convention: /\Date(12341324)\/ because \/ is not necesasry to escape \, so, it is used here to signal date!
Another way is to use military format (or other ISO format) 2007/07/18. The thing is, there is no way to signal that it is indeed a date, not an ordinary string field.


Post a Comment

Subscribe to Post Comments [Atom]

<< Home