| Barbara Deaton 2006-04-07, 1:28 pm |
| I'm using the MySQL 5.0.15 client to a 5.0 server all 32-bit windows.
It appears that the UNSIGNED_FLAG is being returned for column types of =
timestamp.
Checking the flags variable of the MYSQL_FIELD structure indicates that =
the following flags are returned:
Field->flags =3D 1249
NOT_NULL_FLAG =3D 1
UNSIGNED_FLAG =3D 32
ZEROFILL_FLAG =3D 64
BINARY_FLAG =3D 128
TIMESTAMP_FLAG =3D 1024
Flag value totals =3D 1249.
I thought the TIMESTAMP_FLAG was deprecated so I was surprised to see it =
returned and I'm not sure why the UNSIGNED_FLAG is returned.
You can create an unsigned timestamp column:
mysql> create table barbts (col1 timestamp unsigned, col2 int unsigned);
ERROR 1064 (42000): You have an error in your SQL syntax; check the =
manual that
corresponds to your MySQL server version for the right syntax to use =
near 'unsig
ned, col2 int unsigned)' at line 1
Is this correct behavior that the UNSIGNED_FLAG is returned and if so =
can you tell me the justification?
Thanks for any information.
Barbara
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|