Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 25 Jul 2011, 19:49
Ethelbert Ethelbert is offline
 
Join Date: Feb 2007
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?
Reply With Quote
  #2  
Old 26 Jul 2011, 01:42
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
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.
Reply With Quote
  #3  
Old 27 Jul 2011, 18:19
Ethelbert Ethelbert is offline
 
Join Date: Feb 2007
This is inside my config.php

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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?
Reply With Quote
  #4  
Old 28 Jul 2011, 05:31
Konstantinos's Avatar
Konstantinos Konstantinos is offline
 
Join Date: Apr 2006
Originally Posted by Ethelbert View Post
This is inside my config.php

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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?
http://www.vbulletin.com/forum/showt...=1#post1816873
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 14:48.

Layout Options | Width: Wide Color: