miniBB ®

miniBB

®
Support Forums
  
 · Start · Sign in · Register · Search · Statistics · File Bank · Manual ·
Specific miniBB Support Forums / Specific /  
 

utf8_general_ci

 
Author danielsos2
Partaker
#1 · Posted: 24 Nov 2014 21:38Reply Quote
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 Lead Developer
#2 · Posted: 24 Nov 2014 22:31Reply Quote
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:18Reply Quote
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

BB code for the Bold StyleBB code for the Italic StyleBB Code for the PictureBB code for the URLUpload a File

  ?
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
Check out the File and Picture Attachments add-on: extend your miniBB-forums, attaching images and files.