Re: Unicode error with PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 26 Sep 2006 12:05:56 -0600, Tony Grimes wrote:

> I'm getting the following error when PHP tries to insert a Unicode character
> (the problem word is resume with the accents) into a PostgreSQL database:
> 
> pg_exec(): Query failed: ERROR:  Invalid UNICODE character sequence found
> (0xe97375)
> 
> I can't figure out why I'm getting the error. The HTML form is utf-8 and the
> database is UNICODE, but I'm still getting the error. Is there some problem
> with the PHP library? Is there a PHP setting that controls character
> encoding within scripts? Any help would be appreciated.

   0xe97375 is "ésu"[1] in a lot of code pages such
as ISO-8859-1, and Windows cp1252. It is NOT a valid
UTF-8 sequence. I would guess that the form is sent
using one of those code pages and not UTF-8.


  --nfe

[1]: e-acute, s, u

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux