search

hgourvest / node-firebird

Pure javascript and asynchronous Firebird client for Node.js.
Mozilla Public License 2.0
257 stars 128 forks source link

Blob error if the subtype isn't binary #307

Open felipedllinfo opened 1 year ago

felipedllinfo commented 1 year ago

Hi, I have an issue, there is a blob colum that isn't subtype binary and when i made a select and try to save the file it isn't recording correctly. i try to cast in select but without success.

felipedllinfo commented 1 year ago

Updating the case, I try to do this cast: SELECT CAST(CAST(X.CBD_VLR_BLB AS BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE) AS BINARIO) FROM CBD_CONFIGURACOESBD X WHERE X.CBD_DSC = key

but it doesn't work, i create a new field with this set and it works. But i need to use this field, because the system works with it.