deemytch

deemytch

TDS: Inserting binary into VARBINARY won't work

I try to insert binary string into VARBINARY field in MSSQL table.

If my string have symbols 0-10 TDS recognizes that that is a binary and insertion works.

Otherwise it fails.

This one works:
iex(2)> TdsTest.TestRepo.insert(%TdsTest.Rawdata{ID: UUID.uuid4(), FVarBin: <<1,2,3,4,5>>})
11:24:02.963 [debug] QUERY OK source=“Rawdata” db=10.5ms queue=2.0ms idle=228.8ms
INSERT INTO [dbo].[Rawdata] ([ID],[FVarBin]) VALUES (@1, @2) [“759b8945-d13b-4190-845f-91f343735bc2”, <<1, 2, 3, 4, 5>>]

But that won’t:

iex(3)> TdsTest.TestRepo.insert(%TdsTest.Rawdata{ID: UUID.uuid4(), FVarBin: <<32,33,34,35>>})
11:24:15.535 [debug] QUERY ERROR source=“Rawdata” db=0.0ms queue=1.4ms idle=812.4ms
INSERT INTO [dbo].[Rawdata] ([ID],[FVarBin]) VALUES (@1, @2) [“7fd4d3de-b0c9-4a79-b3f1-6f9c31e1c8f4”, " !"#"]

That’s coming from database: “** (Tds.Error) Line 1 (Error 257): Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.”

FVarBin is VARBINARY(MAX), but that won’t work also with any VARBINARY(N) type.

What should I do to make that working?
I posted test project on github TDS VARBINARY test

Where Next?

Popular in Questions Top

sergio
In Ruby, I can go: User.find_by(email: "foobar@email.com").update(email: "hello@email.com") How can I do something similar in Elixir? ...
New
vertexbuffer
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
New
myronmarston
The Elixir Typespec docs show the following syntax for keyword lists in typespecs: # ... | [key: type] # keyword lists...
New
JeremM34
Hello, how can I check the Phoenix version ? Thanks !
New
ovidiubadita
Hey all, I discovered Elixir and I love it. I always wanted to learn a functional programming and I intended to go for Haskell, but afte...
New
minhajuddin
I have seen a lot of code which picks the first element from a list using Enum.at(0) instead of List.first. Is there a reason why people ...
New
vegabook
I’m brand new to Phoenix and I have stripped one of the demo applications to the bone. I just want to get an svg up on the screen. Here i...
New
alice
Hey, Just curious what are the main benefits of Elixir compared to Clojure? When is Elixir more useful than Clojure and vice versa? Th...
New
belgoros
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New

Other popular topics Top

aadeshere1
I have a another noob question about loop. Since elixir is immutable, while loop is not directly possible. total = 10 while total != 0 ...
New
malloryerik
Hi, this is for people who, like me, have had some friction using .html.heex templates in VSCode. The solution seems to be, in a hyphena...
New
Darmani72
If I have a post route which an argument: post /my_post_route/:my_param1, MyController.my_post_handler How would get the post params ...
New
senggen
Erlang/OTP 25 [erts-13.2.2] [source] [64-bit] [smp:8:8] [ds:8:8:10] [async-threads:1] 15:22:35.803 [error] gen_event {lager_file_backend...
New
albydarned
Hello all! I am typing this post from my new MacBook Pro with the M1 chip. I’m loving it so far, and will probably use it as my daily dr...
New
greenz1
I have a phoenix application from which a user can download multiple(5-6) files of size 1MB. I couldn’t find anything related to sending ...
New
JeremM34
Hello, how can I check the Phoenix version ? Thanks !
New
ovidiubadita
Hey all, I discovered Elixir and I love it. I always wanted to learn a functional programming and I intended to go for Haskell, but afte...
New
baxterw3b
Hi guys, i’m new in the Elixir world, and i have to say, that i love it! i’m having some problem to understand anonymous functions with ...
New
romenigld
I am trying to run a deploy with docker and I successfully runned with this command: docker build -t romenigld/blog-prod . but when I t...
New

We're in Beta

About us Mission Statement