[urgent] vbulletin not able to search Thai language
 

Many of my friends who bought Vbulletin 4.0.3 license, told me that they are not able to search the Thai language under tis620_thai_ci as database collation. Search only working when using English keyword.

Thus some of them decided to using UTF-8 and problem as the workaround.
But, my situation is difference I don't want to switch to UTF-8 since I got existing forum on IPB which currently using tis620_thai_ci as collation.

So, I am not sure whether once I buy the new license, any support able to help me fix this problem or not.

Now this problem block me to buy the license.

Here is current mysql configuration

Code:
character set client utf8
(Global value) tis620

character set connection utf8
(Global value) tis620

character set database tis620
character set filesystem binary
character set results utf8
(Global value) tis620

character set server tis620
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_general_ci
(Global value) tis620_thai_ci

collation database tis620_thai_ci
collation server tis620_thai_ci



here is my current my.cnf

Code:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

default-character-set=tis620

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
open_files_limit= 3600


[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
# If you make changes to these settings and your system uses apparmor, you may
# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking

default-character-set=tis620
collation-server = tis620_thai_ci
character-set-server =tis620
init-connect='SET NAMES tis620'