LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 05-08-2008, 11:41 AM   #1
helptonewbie
Member
 
Registered: Aug 2006
Location: England Somewhere
Distribution: Mandriva, PCLinuxOS, Karoshi, Suse, Redhat, Ubuntu
Posts: 518

Rep: Reputation: 39
Question Mysql 4-5 migration as well as character set migration from latin1 to utf8?


Hi All,
I have no problem setting up mysql 5 for utf8 (i've read its utf8 by default for mysql 5 however i don't believe this as mysql 5 docs say its still latin1 Swedish as always). The problem i'm having is just how difficult is this, i've been briefly reading into a few sites that say several ways to do this, and then come talk about the requirement of re-indexing everything, well i'm thinking if i iconv everything if that is a correct method and then would it still be able to re-index....

Plus we have some really complicated serialized arrays in the mysql database will things like this be effected??

I don't know a huge amount about mysql but i'm slowly going forward with it, any help is appreciated and i look forwards to your comments.

Cheers Regards,
..
 
Old 05-09-2008, 06:50 AM   #2
mahmoud
Member
 
Registered: Apr 2006
Location: UK
Distribution: Mandriva, Debain, Redhat, Fedora, Ubuntu, FreeBSD
Posts: 269

Rep: Reputation: 30
hi
if you are using apache you can add
AddDefaultCharset utf-8
to the virtual hosts file for the site it has happened to me as well
also you chave to change the charset in mysql with
alter table "tablename" charset=utf8;
it should work
 
Old 05-09-2008, 07:15 AM   #3
helptonewbie
Member
 
Registered: Aug 2006
Location: England Somewhere
Distribution: Mandriva, PCLinuxOS, Karoshi, Suse, Redhat, Ubuntu
Posts: 518

Original Poster
Rep: Reputation: 39
Hi...thanks for the reply..
I'm also under the impression that i will need to transform the current latin1 Swedish data to be utf8 characters...this is i believe very important? And i'm wondering what the best method may be as there appears to be several however people don't seem to be shouting about any method in particular that works excellent every time.

Cheers
 
Old 05-15-2008, 06:15 AM   #4
helptonewbie
Member
 
Registered: Aug 2006
Location: England Somewhere
Distribution: Mandriva, PCLinuxOS, Karoshi, Suse, Redhat, Ubuntu
Posts: 518

Original Poster
Rep: Reputation: 39
is there any sort of select * from table ;paste to table with convertion of latin1 to utf8 characters probably not but worth an ask.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: JBoss: Hypersonic to mysql migration LXer Syndicated Linux News 0 06-18-2007 07:16 PM
MySQL Migration Help matrixcubed Linux - Software 2 06-05-2005 01:41 PM
Migration osiris69 Linux - General 4 03-27-2005 09:41 PM
migration away from qmail Deltron3030 Linux - General 1 02-17-2004 05:01 PM
Migration digimak Slackware 2 10-06-2003 01:48 PM


All times are GMT -5. The time now is 09:05 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration