Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 08-16-2015, 05:36 PM
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
Location: Turkey/Ankara
Posts: 72
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default A Strange Problem With Special Characters

Hello,

I am facing with a strange problem that i can not solve since 1 month. Everything started right after i upgrade my php version from 5.3 to 5.5 for update vbulletin from 4.2.2 to 4.2.3

Problem is some special characters and letters in some different languages (like Russian, Polish etc..) looks not right. Here are few examples:

?„? --> ?
?€? ---> ?
?€˜ --> ?
Ğ?Ğ??€ --> мир
?šwiata --> Świata

My forum charset is ISO-8859-9 because my forum is Turkish. Database collation is latin1_swedish_ci

when i run this query though phpmyadmin SHOW VARIABLES LIKE 'char%' i am getting this result:



Before upgrade vB i have full backed up and after this problem i restored it back but still i have this strange problem. I think something is about php version but i am not sure.

I've created support ticket on vbulletin.com but no one care or answer. I've tried many things but so far no any solution.

I hope someone here could help, thank you in advance.
Reply With Quote
  #2  
Old 09-12-2015, 10:41 AM
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
Location: Turkey/Ankara
Posts: 72
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No one could help me ?
Reply With Quote
  #3  
Old 09-12-2015, 10:56 AM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is it correctly stored in the database and incorrectly displayed on the forum or also stored incorrectly in the database?
Reply With Quote
  #4  
Old 02-14-2016, 12:40 PM
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
Location: Turkey/Ankara
Posts: 72
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dave View Post
Is it correctly stored in the database and incorrectly displayed on the forum or also stored incorrectly in the database?
I've been looking for solution since i created this thread until now, still no way out...

It's incorrect at both side.

This is how it's look on forum:



And this is how it's look on database:

Reply With Quote
  #5  
Old 02-16-2016, 01:57 PM
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
Location: Turkey/Ankara
Posts: 72
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've solved this problem by converting my db to utf8 but i have small issue with utf8.

Only in dates monts names which containing Turkish characters looks like this:



Rest of is ok, i have this issue only in dates. Any idea why this is happening ?
Reply With Quote
  #6  
Old 02-28-2016, 10:56 AM
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
Location: Turkey/Ankara
Posts: 72
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Charset problem in dates resolved by adding this to functions.php file "$currentlocale = setlocale(LC_TIME,'tr_TR.UTF-8');"

Thanks to everyone who didnt help )
Reply With Quote
  #7  
Old 10-07-2016, 05:20 AM
Bulent Tekcan Bulent Tekcan is offline
 
Join Date: Oct 2003
Location: TURKEY - Istanbul
Posts: 437
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Merhaba blue7

Aynı bela benim başımda var, bende Türkçe karakter sorunu yok ama Euro üstten tırnak vs. gibi şeylerde oluyor. Tapatalk ile bakınca copy paste yapılan bazı konular rezalet görünüyor. Aynı durumda php 5.3 te iken sorun yoktu bu salak 4.2.3 davasına geçtik mecbur güncelledik ve başladı. Tam olarak ne yaptınız bana özel mesajla yazarmısınız rica etsem. Çünkü bizde 14 milyona yakın mesj var riskli bir iş.

Saygılar
Reply With Quote
  #8  
Old 10-10-2016, 09:36 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Bulent Tekcan View Post
Merhaba blue7

Aynı bela benim başımda var, bende T?rk?e karakter sorunu yok ama Euro ?stten tırnak vs. gibi şeylerde oluyor. Tapatalk ile bakınca copy paste yapılan bazı konular rezalet g?r?n?yor. Aynı durumda php 5.3 te iken sorun yoktu bu salak 4.2.3 davasına ge?tik mecbur g?ncelledik ve başladı. Tam olarak ne yaptınız bana ?zel mesajla yazarmısınız rica etsem. ??nk? bizde 14 milyona yakın mesj var riskli bir iş.

Saygılar
Please post in English, as per the forum rules.
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 04:42 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.13426 seconds
  • Memory Usage 2,227KB
  • Queries Executed 13 (?)
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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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_postinfo_query
  • fetch_postinfo
  • 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