[Correction] Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding
| From: | Neil Smith [MVP, Digital media] | Date: | Mon, 23 Jul 2007 21:03:48 +0000 |
| Subject: | [Correction] Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43854@lists.php.net to get a copy of this message | ||
The solution is pretty simple once you hit it, and works in both MySQL and PGSQL because it's standard SQL-92 : $query="SET NAMES 'UTF-8'";Sorry - I meant $query="SET NAMES 'UTF8'"; As you pointed out, it's UTF8 not UTF-8 ;-) Cheers - Neil