Re: Storing Special Characters

Tirsdag 14. mai 2013 18.05.05 skrev Rebecca Clarke:
> Hi there.
>
> This may be the wrong forum to inquire in, but I'd be grateful if I could
> directed in the right direction if that is the case.
>
> I am currently using Postgresql 9.1.
>
> I have a table in which I want to store shop names. Some of the shop names
> contain 'é' and '£'.
>
> The query below works when I run it through pg_admin:
>
> insert into retail(storename) values ('£'::character varying)
>
> However, when I run the same query through pg_query in PHP, I get:
>
> PHP Warning: pg_query(): Query failed: ERROR: invalid byte sequence for
> encoding "UTF8": 0xa3

It's possibly a client encoding problem. See the PHP documentation on

http://php.net/manual/en/function.pg-set-client-encoding.php

regards, Leif