vb.org Archive - Website charset vs. database collation

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Website charset vs. database collation (https://vborg.vbsupport.ru/showthread.php?t=267410)

Ethelbert

07-25-2011 06:49 PM

Website charset vs. database collation

Hello,
I hope that someone will give me good answer to me :)

My database had 2 collations: latin2_czech_cs and utf8_general_ci... I have transferred everything to utf8_general_ci...Everything works great, but I have one issue...

My language and entire site is in iso-8859-2
DB is is utf8_general_ci
my config.php contain collation latin2

How is possible that everything works without problem? Without any character problem? When I change website charset to utf8, everything is broken... How can chat everything to utf8?

kh99	07-26-2011 12:42 AM

I don't know what you mean when you say "my config.php contain collation latin2" - I see a way to set the charset in the config.php but not the collation.

Anyway, I don't really know much about charsets and collation, but I had a look at the vb code and the MySQL manual and I think what you have works because the MySQL server translates the results from the database before sending them. If this is correct, then you should be able to change to utf8 by adding $config['Mysqli']['charset'] = 'utf8'; in your config.php.

Ethelbert

07-27-2011 05:19 PM

This is inside my config.php

Code:

$config['Mysqli']['charset'] = 'latin2';

Database is saying, that content is in utf8_general_ci.... My language is in iso-8859-2... When I change it to utf8 and charset in the config.php change to utf8, my website is broken...

How can I convert my DB and website to UTF8?

Konstantinos

07-28-2011 04:31 AM

Quote:

Originally Posted by Ethelbert (Post 2225681)

This is inside my config.php

Code:

$config['Mysqli']['charset'] = 'latin2';

http://www.vbulletin.com/forum/showt...=1#post1816873

All times are GMT. The time now is 04:29 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00973 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: