Convert Database Latin1 to Utf8

Hello ,

 I have database vBulletin , i wont to change it from latin1 to utf8
NoBoDyDDAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
While you can easily change the "collation", that does Not change the actual characters.  And if you are having display problems, it will not change that.  That only changes things like how a table is sorted because 'latin' character set does not have all the characters at the same code points as UTF-8.  In general, changing an existing database that has been working is not a good idea.
NoBoDyDDAuthor Commented:
hello ,

but i wont to change it ..
isee some command via ssh to convert it but it was unlikely
Dave BaldwinFixer of ProblemsCommented:
If you have phpMyAdmin available on that server, you can use it to change it.  However... each table and even each column can have the 'collation' declared separately.  You may also need 'root' access to change all of the tables.  Here http://dev.mysql.com/doc/refman/5.5/en/mysql.html is info on using the 'mysql' command line program.  And here is info on character sets and collations:  http://dev.mysql.com/doc/refman/5.5/en/globalization.html
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

NoBoDyDDAuthor Commented:
can u give a command to do it via ssh ^^

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave BaldwinFixer of ProblemsCommented:
I just did.  'mysql' is also a command line program that you can run thru an SSH connection.  If you are looking for a single command that will do what you want, it does not exist.  You have to go thru the databases and tables one by one and change them.
NoBoDyDDAuthor Commented:
Hello ,

do u know any script do the convert automatic
or do u  know a export company
Dave BaldwinFixer of ProblemsCommented:
No, I don't.  I have never heard of anyone doing this because it causes too many problems.
NoBoDyDDAuthor Commented:
hey again ,
i found this tool and it was a great
but i see blank page becasue my database size 7.1 Gb
he change every tables but not all of them
http://www.phoca.cz/download/category/17-phoca-changing-collation-tool
?
what u think ?
Dave BaldwinFixer of ProblemsCommented:
What ever works for you.  I don't have time to look at it.
NoBoDyDDAuthor Commented:
worked
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.