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