417 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
45
views
How to BULK INSERT hex strings into a VARBINARY column in Azure SQL (from CSV) without staging?
I am loading data from Parquet into Azure SQL Database using this pipeline:
Parquet → PyArrow → CSV (Azure Blob) → BULK INSERT
One column in the Parquet file is binary (hashed passwords).
PyArrow CSV ...
0
votes
1
answer
103
views
How to convert (SQL) VARBINARY hashed password and salt columns to String for ASP.NET Core Web API
In my SQL Server legacy User table, I have the following columns (which I cannot change):
UserName: VARCHAR(50)
PasswodsHashed: VARBINARY
PasswordSalted: VARBIANRY
This table has thousands of records ...
0
votes
1
answer
275
views
Convert MSSQL image / varbinary column data to file
I have data from an (unknown) MSSQL server, in a column of type Image (I think this is an old variant of varbinary).
I want to make a script (preferably in Python or Typescript, but open for anything) ...
1
vote
1
answer
523
views
Left side of LIKE expression must evaluate to a varchar (actual: varbinary). What's an alternative to converting from varbinary to varchar?
I have the following query on dune.com:
SELECT
th.value / 1e18 as amount,
tr.success,
th."from",
th.to,
tr.hash,
tr.data,
FROM
table1 tr
table2 th ON tr.hash = th.evt_hash
...
1
vote
1
answer
247
views
In SQL Server, can I get data from XML compressed in ZIP/RAR file saved as VARBINARY
I have a table column contains VARBINARY (data like 0x...) [Column name is LDATA]
I just want to be simple to be understood.
The software puts in LDATA column a ZIP/RAR contains one XML file.
To reach ...
0
votes
2
answers
491
views
Retrieve VARBINARY from SQL Server table using FileStream to save file in VB.Net
I have stored data in a SQL Server table and I need to retrieve it through FileStream to save it back as a png picture as it was before.
I can't understand or find a way to do this, I read many ...
0
votes
0
answers
45
views
Preview a varbinary file stored in database on a new tab instead of downloading using ASP.NET MVC
I have search on the net but couldn't find what I'm looking for. I have a simple app in ASP.NET MVC using C# that lets you upload a file and stored it in a database. That works fine. However, when it ...
0
votes
1
answer
331
views
Set varbinary size in Entity Framework C#
I am working with the code first approach, here is the POCO object I am using
public class Fotografia
{
// Fotografía
[Display(Name = "Fotografía")]
public required byte[] ...
0
votes
0
answers
80
views
Incorrect insertion of data into the table
I have a table for storing images in a database (#TempImage). It contains the following columns:
Image_ID
Obj_id
Body
TYPE
1
22
0x89504E470D0A1A0A0000000D494844
image/png
2
23
...
0
votes
0
answers
60
views
Sync data between instances using binary data
I sporadically sync data from a small set of tables in production. I cannot access the production machine directly, so historically
I submit "select * from dbo.source",
DBA copies from ...
2
votes
1
answer
916
views
Correctly store and retrieve PDF file using SQL database with .NET
I have created a Web Application which sends PDF files to an SQL database table to later be loaded and sent via Email. Currently my code works and PDF file is being sent in Email, however once opening ...
0
votes
1
answer
213
views
Specific Effects of using nvarbinary vs nvarchar for storing images
I have seen the statement that if you are storing images in a column in a SQL Server database, you should use varbinary instead of nvarchar. Which makes 100% sense to store binary data as varbinary ...
0
votes
0
answers
120
views
Error opening a Word doc file downloaded from a SQL SERVER Image field
I have a SQL SERVER 2017 database in which there is a table containing records with a field of type Image. There are Word doc files in this field. When I try to download the contents of these fields ...
0
votes
1
answer
391
views
Reading VARBINARY via SQLAlchemy
I am working on a base-datatable with a VARBINARY variable. Now I want to read the table via SQLAlchemy into a pandas dataframe. Going the usual way
df = pandas.read_sql_query("select key from ...
0
votes
0
answers
364
views
Upload PDF as binary data to SQL Server via NEXT.js app
I am trying to solve this problem:
I am building an app in NEXT.js where users should upload certain documents (pdf,docx,etc.). I need to store those documents inside SQL Server as blobs. I do not ...