Charset Problem
| From: | Gerske, Sebastian | Date: | Thu, 29 Jul 2004 12:37:55 +0000 |
| Subject: | Charset Problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-192178@lists.php.net to get a copy of this message | ||
Dear list,
im running mysql 4.1 and php 4.3.8 and have the following problem with
charset. If i select a row from a table like
SELECT *
FROM ip
WHERE ip
LIKE '127.0.0.1'
LIMIT 0 , 30
i get the error:
#1267 - Illegal mix of collations (ascii_general_ci,IMPLICIT) and
(latin1_swedish_ci,COERCIBLE) for operation 'like'
the database is completly configured as ascii charset so i need to know how
to i change the charset from swedish (latin1) to ascii in php ?
btw i configured php as --with-mysql/usr/local/mysql
thanks for answers
s gerske