Save Image of QGraphicview in SqlServer
-
Hi,
Are using a QGraphicsPixmapItem ?
-
hi
maybe this is interesting
https://wiki.qt.io/How_to_Store_and_Retrieve_Image_on_SQLite
Its using BLOBS.I dont know what IMAGE does a field type.
If its a MS SQL server, i think you should look into
VarBinary(max). -
hi
maybe this is interesting
https://wiki.qt.io/How_to_Store_and_Retrieve_Image_on_SQLite
Its using BLOBS.I dont know what IMAGE does a field type.
If its a MS SQL server, i think you should look into
VarBinary(max). -
@M4RZB4Ni said:
IMAGE DataType
Ok, i must have misunderstood
https://msdn.microsoft.com/en-us/library/ms187993.aspx
"
IMPORTANT! ntext, text, and image data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead."Regardless, its still just a BLOB and the example should work also. :)
-
@M4RZB4Ni said:
IMAGE DataType
Ok, i must have misunderstood
https://msdn.microsoft.com/en-us/library/ms187993.aspx
"
IMPORTANT! ntext, text, and image data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead."Regardless, its still just a BLOB and the example should work also. :)
@mrjj
Thank You So Much
i have one Other Question
if i have to Select or Insert on a Sql Server Database
and this Database Placed on Other Computer on Network(server)
if i just change the Server Name in my Connection enough?
Thanks so much againThanks
M4RZB4Ni -
@mrjj
Thank You So Much
i have one Other Question
if i have to Select or Insert on a Sql Server Database
and this Database Placed on Other Computer on Network(server)
if i just change the Server Name in my Connection enough?
Thanks so much again -
Depending on your other server setup, you might also have to change the credentials.
-
@M4RZB4Ni
Hi
If client pc (your program) and the the database server is on same local lan then
YES, should not matter in most networks.
