The Community Forums

Interact with an entire community of cPanel & WHM users.
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql error

Discussion in 'General Discussion' started by frank-norge, Jun 21, 2006.

  1. frank-norge

    frank-norge Member

    Joined:
    Mar 23, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    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
     
    #1 frank-norge, Jun 21, 2006
    Last edited: Jun 21, 2006
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    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.
     
  3. frank-norge

    frank-norge Member

    Joined:
    Mar 23, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  4. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    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
     
Loading...

Share This Page