You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Above capture, FilePath is integer type in create statement. So, data is right aligned and comma separated.
But it is not actually an integer data and should be left aligned and no comma separation applied.
BTW, this is not something I do. I am provided with the database and need to struggle with it now.
Thank you for your consideration.
The text was updated successfully, but these errors were encountered:
Yes, this is not supported in HeidiSQL. The data type is detected once, and then used for all values in a grid. I see no way to display different types of data in one column.
Preconditions
Describe the bug
To Reproduce
Check here for some details: https://dba.stackexchange.com/questions/106364/text-string-stored-in-sqlite-integer-column
Screenshots or Crash reports
Above capture, FilePath is integer type in create statement. So, data is right aligned and comma separated.
But it is not actually an integer data and should be left aligned and no comma separation applied.
BTW, this is not something I do. I am provided with the database and need to struggle with it now.
Thank you for your consideration.
The text was updated successfully, but these errors were encountered: