miniBB ® 

miniBB

®
Support Forums
  
 | Start | Register | Search | Statistics | File Bank | Manual |
Specific miniBB Support Forums / Specific /  
 

utf8_general_ci

 
Author danielsos2
Partaker
#1 | Posted: 24 Nov 2014 21:38 
Hello,

Sorry, I speak a little english.

I would like install miniBB 3.1 forum with Hungarian language pack.

1. ~/_install_mysql.sql (utf8_general_ci)

CREATE TABLE minibbtable_banned ( ... ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE minibbtable_forums ( ... ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE minibbtable_posts ( ... ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE minibbtable_send_mails ( ... ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE minibbtable_topics ( ... ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE minibbtable_users ( ... ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2. ~/lang/hun.php (save as UTF-8 without BOM)

$l_meta='<meta http-equiv="content-type" content="text/html;charset=utf-8">'; // $l_meta='<meta http-equiv="content-type" content="text/html;charset=iso-8859-2">';
3. What next?

Example:

I would like see in forum and database: árvíztűrő tükörfúrógép
The board I see as: árvíztűrő tükörfúrógép (it's ok)
I see in minibbtable_forums table, forum_name row is wrong in utf8_general_ci (contains wrong characters).

Please, help me!

Author Paul
Lead Developer 
#2 | Posted: 24 Nov 2014 22:31 
danielsos2:
I see in minibbtable_forums table, forum_name row (utf8_general_ci)
It very depends on the software which you are using to check this data in DB. This software also should have utf8_general_ci as default encoding (you could check it in the View -> Source of the page).

Author danielsos2
Partaker
#3 | Posted: 25 Nov 2014 12:18 
3. ~/setup_mysqli.php

// var_dump ( mysqli_character_set_name ( $mysqlink ) );
// string(6) "latin1"

mysqli_set_charset ( $mysqlink, 'utf8' );
The board I see as: árvíztűrő tükörfúrógép (it's ok)
I see in minibbtable_forums table, forum_name row (utf8_general_ci): árvíztűrő tükörfúrógép (it's ok)

Have a nice day!

Specific miniBB Support Forums / Specific /
 utf8_general_ci
 Share Topic's Link

Your Reply Click this icon to move up to the quoted message


  ?
Post as a Guest, leaving the Password field blank. You could also enter a Guest name, if it's not taken by a member yet. Sign-in and post at once, or just sign-in, bypassing the message's text.


Before posting, make sure your message is compliant with forum rules; otherwise it could be locked or removed with no explanation.

 

 
miniBB Support Forums Powered by Forum Software miniBB ® Home  Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contact Us
Install the Captcha add-on: protect your miniBB-forums from the automated spam and flood.


  ⇑