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

utf8_general_ci

Author danielsos2
Registered
#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: rvztűrő tkrfrgp
The board I see as: rvztűrő tkrfrgp (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 wrong)

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
Registered
#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: rvztűrő tkrfrgp (it's ok)
I see in minibbtable_forums table, forum_name row (utf8_general_ci): rvztűrő tkrfrgp (it's ok)

Have a nice day!

Specific miniBB Support Forums / Specific / utf8_general_ci Top

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

 Short link for this topic:

 ?
You are welcome to post anonymously, by entering a nickname with no password (if the similar Username has not been taken yet), or by leaving both fields empty. If you have a forums account, you can also sign in from this page without posting a message, or sign in and post at once.


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 ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Check out the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB