Solved

Convert Database Latin1 to Utf8

Posted on 2014-10-15
10
133 Views
Last Modified: 2014-10-24
Hello ,

 I have database vBulletin , i wont to change it from latin1 to utf8
0
Comment
Question by:NoBoDyDD
  • 5
  • 5
10 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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
 

Author Comment

by:NoBoDyDD
Comment Utility
hello ,

but i wont to change it ..
isee some command via ssh to convert it but it was unlikely
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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
 

Accepted Solution

by:
NoBoDyDD earned 0 total points
Comment Utility
can u give a command to do it via ssh ^^
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:NoBoDyDD
Comment Utility
Hello ,

do u know any script do the convert automatic
or do u  know a export company
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
No, I don't.  I have never heard of anyone doing this because it causes too many problems.
0
 

Author Comment

by:NoBoDyDD
Comment Utility
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
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
What ever works for you.  I don't have time to look at it.
0
 

Author Closing Comment

by:NoBoDyDD
Comment Utility
worked
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now