miniBB Support Forums | 15 years on The Web
miniBB ®

miniBB

®
  
 | Begin | Register | Reply | Search | Statistics | Manual |
Specific miniBB Support Forums / Specific /   
 

utf8_general_ci

 
Author danielsos2
Partaker
#1 | Posted: 24 Nov 2014 21:38 | Edited by: danielsos2 
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 | Edited by: danielsos2 
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 our forum posting rules. If not, it may be locked or deleted 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
Proceed with the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
↑ TOP