Skip to content

bytea insert doesn't convert properly #33

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
jamshidh opened this issue Dec 15, 2013 · 4 comments
Open

bytea insert doesn't convert properly #33

jamshidh opened this issue Dec 15, 2013 · 4 comments

Comments

@jamshidh
Copy link

I would expect an insert of the form

run conn "INSERT INTO documents VALUES (?)" [toSql $ data]

to insert the data in the bytestring as is into the table, but instead it does some processing to the data first (unescaping backspace octal sequences, and checking that the data only contains valid utf8 characters).

I have written more details about this at http://stackoverflow.com/questions/20506922/how-do-a-put-binary-data-into-postgres-through-hdbc/20598912 (see the response by jamshidh), including a conversion function that I used to fix the problem.

@TravisWhitaker
Copy link

I just ran into this issue as well. If I have the time I'll start working on a patch within the next few days.

@jtdaugherty
Copy link

I also just encountered this with HDBC-postgresql version 2.3.2.3.

@wavewave
Copy link

Any progress here?

@hesselink
Copy link
Member

Not by me, sorry. Would changing this break people's code? And would someone be interested in sending a PR?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants