View Single Post
  #1  
Old 06-21-2007, 02:59 AM
baraban baraban is offline
 
Join Date: Sep 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Has anyone gotten vbulletin to work wih utf-8 db tables?

I am running vbulletin 3.6 on linux, php 4.4 and mysql 4.1.13. The database server and tables are already setup as utf-8 and have properly formatted utf-8 data in them, as is evidenced by looking at the data using phpMyAdmin (so please do not reply with links to threads that talk about converting the tables), however, this data does not get rendered properly under Vbulletin.

I have noticed that there are settings:
$config['Mysqli']['charset'] = 'utf8';
$config['Database']['dbtype'] = 'mysqli';

However, this seems to only apply to php 5 and mysql 4.1.3 and above.
How do those of us who must use utf-8 tables with php 4.3+ and mysql 4.1+ get around this problem?

Potential solution could be simply force vbulletin to establish all of its mysql connections as utf-8. I am guessing that since this is not in the configuration file, I will need to add a line in class_core.php, but I have not been able to figure out exactly where this would be. If there is a better solution for dealing with a utf-8 database - please speak up, as well!

P.S. I originally ran into this problem over a year ago and gave up on upgrading to this newer environment from an old vbulletin 2 installation. Now, a year later I am trying again and can still find no additional info. Please help, somebody...
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01799 seconds
  • Memory Usage 1,760KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete