frank-norge

Member
Mar 23, 2005
11
0
151
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
 
Last edited:

webignition

Well-Known Member
Jan 22, 2005
1,880
0
166
frank-norge said:
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

Member
Mar 23, 2005
11
0
151
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

Well-Known Member
PartnerNOC
May 29, 2004
2,221
4
193
Minneapolis, MN
frank-norge said:
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