UTF-8 for bytea
When trying to INSERT on Postgres (9.1) to a bytea column, via E''
escaped strings, I get the strings rejected because they're not UTF8.
I'm confused, since bytea isn't for strings but for binary. What
causes this? How do I fix this? (I know that escaped strings is not
the best way for binary data, but this is what I'm stuck with for now
- it's a legacy system which I need to maintain.)
On Thu, Nov 3, 2011 at 4:34 AM, Robert James <srobertjames@gmail.com> wrote:
When trying to INSERT on Postgres (9.1) to a bytea column, via E''
escaped strings, I get the strings rejected because they're not UTF8.
I'm confused, since bytea isn't for strings but for binary. What
causes this? How do I fix this? (I know that escaped strings is not
the best way for binary data, but this is what I'm stuck with for now
- it's a legacy system which I need to maintain.)
Because the query needs to be utf8. So you need to escape
any non-ascii chars in it. Also keep in mind that bytea is double-quoted.
See the docs for details.
--
marko