Solved

Convert Database Latin1 to Utf8

Posted on 2014-10-15
10
135 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 83

Expert Comment

by:Dave Baldwin
ID: 40383108
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
ID: 40383151
hello ,

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

Expert Comment

by:Dave Baldwin
ID: 40383185
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
ID: 40383219
can u give a command to do it via ssh ^^
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40383258
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Author Comment

by:NoBoDyDD
ID: 40385836
Hello ,

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

Expert Comment

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

Author Comment

by:NoBoDyDD
ID: 40385974
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 83

Expert Comment

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

Author Closing Comment

by:NoBoDyDD
ID: 40401588
worked
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Insert Query Help 16 97
Mysqli Query 5 48
MySQL Select latest stock count records 11 58
How to only show database items not chosen from initial captured multi select 11 39
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

23 Experts available now in Live!

Get 1:1 Help Now