Re: Storing Special Characters
От | Leif Biberg Kristensen |
---|---|
Тема | Re: Storing Special Characters |
Дата | |
Msg-id | 1479788.Ki0T84dqFb@balapapa обсуждение исходный текст |
Ответ на | Storing Special Characters (Rebecca Clarke <r.clarke83@gmail.com>) |
Ответы |
Re: Storing Special Characters
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: