I have a large vbulletin database (more than 2gb) of an old website I once had. The website is in Hebrew language and I remember that many years ago the character encoding of my database was latin1 and I converted it to UTF8. I remember I was following a guide on vbulletin.org on how to convert the database. I can't remember what I was doing exactly because it was many years ago, but I remember that after I did this conversion the forum was running fine and the only problem I had was that the search feature didn't work for Hebrew keywords. I solved it by using Sphinx search plugin from Digital Point, but I no longer have this plugin these days and I honestly don't think I need it since the website is dead and I just want to bring up online for nostalgia.

Anyway I want to resolve this search problem without using any additional plugins, I believe there's still something wrong with the database because when I am checking the database on phpmyadmin I can still see that there are some latin1 tables even though the main character encoding is set to UTF8.

I will appreciate if there's anyone who can guide me how to resolve this issue



This is how the database look like right now if it helps: https://imgur.com/a/2V7r0jX



Thank you

Devami...