I have multiple tables with timestamps, so the end result of this error is I cannot access the data tab of any of them connected to MSSQL database. I have to manually change the query to VARCHAR instead of NVARCHAR in order to see data in the tables and run as a query..
Is there any way to turn this off????
SQL Error (529): Explicit conversion from data type timestamp to nvarchar is not allowed.
The MSSQL TIMESTAMP data type is currently sorted into the binary type category. This is wrong I guess, and it's the cause for why HeidiSQL applies a LEFT(CAST()) to it in the data tab.
So, I will need to move that TIMESTAMP data type into the right category. But I'm having problems in understanding Microsoft's intention for timestamp columns. It's not a simple number, and it's not a readable string, end even not some date/time format. If I insert some row in a table with a timestamp, that timestamp value is auto-filled with some binary character. How does HeidiSQL need to display such values? I guess I must do some internal conversion?
So, I will need to move that TIMESTAMP data type into the right category. But I'm having problems in understanding Microsoft's intention for timestamp columns. It's not a simple number, and it's not a readable string, end even not some date/time format. If I insert some row in a table with a timestamp, that timestamp value is auto-filled with some binary character. How does HeidiSQL need to display such values? I guess I must do some internal conversion?
This gives me some cosecutive numeric value in a TIMESTAMP column:
However, attempts to update a TIMESTAMP column seems to be impossible:
But I guess it's ok if at least the value can be seen without triggering some error.
SELECT CAST("Column 2" AS INT) FROM "anse"."dbo"."foo";
However, attempts to update a TIMESTAMP column seems to be impossible:
update "anse"."dbo"."foo" set "Column 2"=34007 where "Column 2"=34006
>> SQL Error (272): Cannot update a timestamp column.
But I guess it's ok if at least the value can be seen without triggering some error.
Code modification/commit
from ansgar.becker,
10 years ago,
revision 8.1.0.4673
MSSQL: Fix handling of TIMESTAMP columns in data tab. See http://www.heidisql.com/forum.php?t=13041
Please login to leave a reply, or register at first.