Chuck, I appreciate your help very much and I understand that a lot of people are asking for your help but please read through the whole thread carefully.
I was quoting the first message from the thread php5/mysqli/real utf-8 support
. I know the thread is about vBgallery but I suspect the person is describing the same problem.
I never said my Classifieds tables use latin swedish. I was guessing that Classifieds uses something else for writing/reading data into the databse, not utf-8.
I have a utf-8 database, my whole server has utf-8 as the default charset. Both vBulletin and Classifieds share the same database. Tables for both programs are in the same database but with different table prefixes.
I am not asking for support for slavic languages but utf-8 support. Utf-8 is used on many English sites as well. Since you keep repeating that you don't support other languages, let's say I am using English but am having problems displaying some characters. It is irrelevant what language I am using. If utf-8 is selected, it should show ALL utf-8 characters. If certain characters are not being displayed correctly, obviously utf-8 is not working correctly. Do we agree on this?
Let me give two examples.
I create a user title or username in vBulletin. This data is entered into the database called "Forum" in a table "vb_example1". Database is utf-8. When I view this data with HeidiSQL directly in the database, the data is the same as I entered it. vBulletin shows all the special characters correctly. You can assume they are English words to which I like to add strange characters to make it fun (this way they are not non-English words).
However, in Classifieds this user title and username are not displayed like they should be but instead some characters are represented with question marks.
I post a comment about one of the ads in the Classifieds. I use English words but again with funny characters to make it interesting.
This time the data gets entered by Classifieds into the database "Forum" but this time table "classifieds_example2". When the comment is posted, Classifieds show all the characters correctly. However when I go to view the data with HeidiSQL, I see empty squares and question marks instead of certain characters in the table. I don't know how vBulletin would display the data from this table "classifieds_example2". Probably it would have similar problems as HeidiSQL.
I had to use MySQLi for vBulletin in order to make utf-8 characters work. Since there is a special setting in the vBulletin config file for MySQLi, I assume that same should apply to Classifieds. Especially since someone issued a patch for Photopost for this same purpose. http://www.photopost.com/forum/showthread.php?t=123800
My guess is Classifieds are not 100% utf-8 compatible and thus not compatible with all vBulletin forums. The excuse of not supporting other languages is a simple way to deny a bug. How is language important if utf-8 is being used? A specific character is the same in English as in any other language.
I would appreciate any help on how to fix this.