First time here? Check out the FAQ!
Ask Your Question
1

Why is my forum turning unicode characters into question marks?Why is my forum turning unicode characters into question marks?
 
   
  
 
 
When I enter characters with diacritics, like ā in a question on my AskBot installation, they are converted to question marks.  Why would that be?  
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 NoahY's avatar

      303
    
 
 
 
 NoahY 
 
 
    asked 13 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
 
  
 
 

        oh, sorry, it was just a MySQL problem...
      
 
 NoahY's avatar NoahY (13 years ago)   
 
 
  
 
  see more comments  
 
 
 
 
 
 1 Answer
  
  
   
 
 
 
 
2
 
 
  
 
 
 
 
 
 
As you can read http://askbot.org/doc/create-database.html
 
create database askbot DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;
grant all privileges on dbname.* to dbuser@localhost identified by 'dbpassword';
 
Most interesting part of this query is utf8_general_ci.
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 Zhiz0id's avatar

      58
    
 
 
 
 Zhiz0id 
 
 
    answered 13 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
 
  
 
 

        Thank you... I think I created the database myself via phpadmin, forgot to check the collation
      
 
 NoahY's avatar NoahY (13 years ago)   
 
 
  
 
  see more comments