Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 16 Aug 2015, 19:36
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
Question 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 12 Sep 2015, 12:41
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
No one could help me ?
Reply With Quote
  #3  
Old 12 Sep 2015, 12:56
Dave Dave is online now
 
Join Date: Jun 2010
Real name: Dave
Is it correctly stored in the database and incorrectly displayed on the forum or also stored incorrectly in the database?
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #4  
Old 14 Feb 2016, 13:40
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
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 16 Feb 2016, 14:57
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
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 28 Feb 2016, 11:56
blue7's Avatar
blue7 blue7 is offline
 
Join Date: Aug 2007
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 07 Oct 2016, 07:20
Bulent Tekcan Bulent Tekcan is offline
 
Join Date: Oct 2003
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 Oct 2016, 23:36
MarkFL's Avatar
MarkFL MarkFL is online now
 
Join Date: Feb 2014
Real name: Mark
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.
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
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 12:38.

Layout Options | Width: Wide Color: