• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

Convert Database Latin1 to Utf8

Hello ,

 I have database vBulletin , i wont to change it from latin1 to utf8
0
NoBoDyDD
Asked:
NoBoDyDD
  • 5
  • 5
1 Solution
 
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.
0
 
NoBoDyDDAuthor Commented:
hello ,

but i wont to change it ..
isee some command via ssh to convert it but it was unlikely
0
 
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
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
NoBoDyDDAuthor Commented:
can u give a command to do it via ssh ^^
0
 
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.
0
 
NoBoDyDDAuthor Commented:
Hello ,

do u know any script do the convert automatic
or do u  know a export company
0
 
Dave BaldwinFixer of ProblemsCommented:
No, I don't.  I have never heard of anyone doing this because it causes too many problems.
0
 
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 ?
0
 
Dave BaldwinFixer of ProblemsCommented:
What ever works for you.  I don't have time to look at it.
0
 
NoBoDyDDAuthor Commented:
worked
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now