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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php