PhotoPost Community - View Single Post

tomzl · May 29th, 2007, 10:13 AM

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.
Example 1
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.

Example 2
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.

May 29th, 2007, 10:13 AM	#16 (permalink)
tomzl Member Verified Customer Join Date: May 2007 Posts: 122	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. Example 1 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. Example 2 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.