Eine Einführung in
|
| SQLite | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to SQLite | ||
| none | ||
| DB2 | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to DB2 | ||
| none | ||
| MS Access | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to MS Access | ||
| The string 'abcdef' is accepted but truncated. The date '10-11-12' is accepted (as UK format). | ||
| PostgreSQL | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to PostgreSQL | ||
| The string 'abcdef' is accepted - but truncated. The date '10-11-12' is accepted (as a UK format). | ||
| Oracle | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to Oracle | ||
| The string 'abcdef' is reject - too long for the VARCHAR(5), '10-11-12' is rejected as a date | ||
| MS SQL Server | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to MS SQL Server | ||
| The string 'abcdedf' is rejected (too long). The date '10-11-12' is accepted (as US format). | ||
| MySQL | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to MySQL | ||
| The string 'abcdef' is accepted but truncated. The date '10-11-12 is accepted as 12th Nov 2010, the date '10 Nov 2012' is not recognised - instead the New Year's day 1 BC is used | ||
| Sybase | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to Sybase | ||
| none | ||
| Mimer SQL | ||
| If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions). | ||
| Specific to Mimer SQL | ||
| none | ||