Results 1 to 2 of 2
Thread: automatic type conversion
May 24, 2004, 08:02 #1
automatic type conversion
i have one question regarding automatic type conversion in INSERT and UPDATE queries on different DMBS.
in mysql you can do the following :
INSERT INTO person (name, age) VALUES ('foo', '26')
mysql will convert the '26' to an integer if the field is declared as integer. is this supported by all other databases (PostgreSQL, Oracle, MSSQL) ?
May 24, 2004, 12:13 #2
- Join Date
- Jan 2004
- Uppsala, sverige
- 2 Post(s)
- 1 Thread(s)
You should not use that syntax in Mysql either.