Thanks everyone for your help.
I changed the encoding as directed on the PHP documentation provided by
Leif to LATIN1 instead of the UTF-8. This resolved the issue and the
records with £ and é inserted into the database without complaint.
On Tue, May 14, 2013 at 11:36 PM, CR Lender wrote:
> O
On 2013-05-15 00:31, Chris Angelico wrote:
> Which, in UTF-8, is represented by the byte sequence C2 A3. (The
> latter would be represented as EC 8A A3.)
Right, my bad.
I read Unicode instead of UTF-8.
- crl
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Wed, May 15, 2013 at 8:20 AM, CR Lender wrote:
> On 2013-05-14 19:32, Paul Jungwirth wrote:
>> The UTF-8 encoding for a pound sign is 0xc2a3, not just 0xa3. You
>> might want to make sure your PHP file is correct.
>
> Just for the record, the Unicode code point for the pound symbol (£) is
> act
On 2013-05-14 19:32, Paul Jungwirth wrote:
> The UTF-8 encoding for a pound sign is 0xc2a3, not just 0xa3. You
> might want to make sure your PHP file is correct.
Just for the record, the Unicode code point for the pound symbol (£) is
actually 0x00A3. 0xC2A3 is the Hangul syllable Syuh (슣).
- crl
The UTF-8 encoding for a pound sign is 0xc2a3, not just 0xa3. You
might want to make sure your PHP file is correct. If you're on Linux,
you can use a command like `od --format=ax1 foo.php` to see the actual
byte values. If that shows the wrong value, then the problem is your
text editor is saving t
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. So
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 whe
