View Single Post
Old June 1st, 2007, 02:18 PM   #42 (permalink)
tomzl
Member
Verified Customer
 
Join Date: May 2007
Posts: 122
That is what I have been saying all along. My vBulletin tables store the data exactly like I enter it (Test蚞đć). Classifieds store these same characters differently.

Classifieds Admin panel shows the categories with special characters exactly how they are stored in the Classifieds tables but on the main page they show them correctly.

Example
Classifieds table: TestΔ?????Δ‘Δ‡
Admin panel: TestΔ?????Δ‘Δ‡
Main Classifieds page: Test蚞đć

What I find strange is that Classifieds store the data the same in MySQL and MySQLi. The problem is that when Classifieds read the data from the vBulletin MySQLi tables, it somehow gets distorted into Test?????.

Example
vBulletin table: Test蚞đć
Classifieds main page: Test?????

When user Test蚞đć posts an ad his username is stored into the Classifieds "products" table as "test?žš??" So basically letters ž and š are carried correctly over from vBulletin but other letters turn into question marks. However on the main Classifieds page even letters ž and š are displayed as question marks and Test????? is displayed as user.
tomzl is offline   Reply With Quote