Mysql error

[frank-norge]

Hello
I get this error in mysql :

Error

SQL query:
ALTER TABLE `filer` CHANGE `st?se` `s torrelse ` VA RCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

MySQL said:
#1300 - Invalid utf8 character string: 'ørrelse'

How can i fix this problem ?

Thanks for all help

I use mysql 4.1 and PHP 5.1

 

[webignition]

MySQL said:
#1300 - Invalid utf8 character string: 'ørrelse'

You might want to try using a string that doesn't contain any invalid utf8 characters.

You might also be able to get things working by specifying a different character set, although I'm not sure if the character set applies to a table's structure as well as a table's contents.

 

[frank-norge]

Update mysql from 4.0 to 4.1

I had never this error before i upgrade mysql from 4.0 to 4.1
And i need to use norwegian caracter

 

[AndyReed]

SQL query:
ALTER TABLE `filer` CHANGE `st?se` `s torrelse ` VA RCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

MySQL said:
#1300 - Invalid utf8 character string: 'ørrelse'

This is a very common issue with MySQL DBs using Scandinavian, Turkish and German languages.
Although I am not sure if this will help, but try it:

mysql> describe WHATEVER_YOUR_TABLE_NAME_AND_ID
mysql> set names utf8;
mysql> show table status;
mysql> show variables;

I also think you should check Php Web site for more information on utf8_decode: http://us2.php.net/utf8_decode