Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 06-21-2007, 03: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
  #2  
Old 06-24-2007, 07:38 AM
baraban baraban is offline
 
Join Date: Sep 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Folks, please help out! I should just be able to "SET NAMES 'utf8'" on line 277 class_core.php in the db_connect routine for mysql and be done with it. However, vbulletin crashes as soon as I attempt to do that or even simply "SET character_set_results = 'utf8'". This type of thing worked for many other applications. I guess vbulletin team worked really hard to make sure your database could not be utf-8...
Reply With Quote
  #3  
Old 06-25-2007, 06:34 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you tried contacting vBulletin Support?
Reply With Quote
Reply

Thread Tools
Display Modes

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

Forum Jump


All times are GMT. The time now is 11:09 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03802 seconds
  • Memory Usage 2,164KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete