From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.50) id 1EZDCS-0001o7-M9 for garchives@archives.gentoo.org; Mon, 07 Nov 2005 20:02:41 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id jA7Jv6qO008759; Mon, 7 Nov 2005 19:57:06 GMT Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id jA7Jg3oo017772 for ; Mon, 7 Nov 2005 19:42:04 GMT Received: (qmail invoked by alias); 07 Nov 2005 19:42:03 -0000 Received: from dslb-082-083-041-147.pools.arcor-ip.net (EHLO mating-tux.renatik.de) [82.83.41.147] by mail.gmx.net (mp007) with SMTP; 07 Nov 2005 20:42:03 +0100 X-Authenticated: #3423037 Date: Mon, 7 Nov 2005 20:41:25 +0100 From: Renat Golubchyk To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] Convert windows-1250 database to UTF-8 Message-ID: <20051107204125.43aaed1a@mating-tux.renatik.de> In-Reply-To: <436F39A2.8000706@lsinter.net> References: <436F358F.8060908@lsinter.net> <436F39A2.8000706@lsinter.net> X-Mailer: Sylpheed-Claws 1.9.15 (GTK+ 2.8.6; i686-pc-linux-gnu) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org Mime-Version: 1.0 Content-Type: multipart/signed; boundary=Signature_Mon__7_Nov_2005_20_41_25_+0100_chNo7c2eDknqNDQr; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Y-GMX-Trusted: 0 X-Archives-Salt: e0f5887c-783c-4f3f-a143-d5623c153675 X-Archives-Hash: a3c1c237efd377c0a0fff0b8570a5e92 --Signature_Mon__7_Nov_2005_20_41_25_+0100_chNo7c2eDknqNDQr Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Mon, 07 Nov 2005 12:25:22 +0100 Khan wrote: > Bruno Lustosa wrote: > > On 11/7/05, *Khan* > > > wrote: > >=20 > > > I'm trying to convert my windows-1250 database to Unicode, > > > UTF-8. Is there any script that can do the job? > >=20 > > What kind of database is it? > > If it's something the likes of postgresql or mysql, you could dump > > the database to a text file, use recode or iconv to change the file=20 > > encoding, and then import it into a new unicode database. >=20 > Yes, that's just what I want to do. Database is MySQL. Can you PLS=20 > explain procedure, I have never done that before. As far as I know you can change the character set directly in MySQL. The data will be converted automagically. For example, ALTER TABLE foo DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci You can create a new table and test it with some garbage data before you do this. And create a backup ;-) Cheers, Renat --=20 Probleme kann man niemals mit derselben Denkweise loesen, durch die sie entstanden sind. (Einstein) --Signature_Mon__7_Nov_2005_20_41_25_+0100_chNo7c2eDknqNDQr Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFDb63oRZZXkGjHI/0RAswlAJ483h66uFuLIgQdeQJQWXDd7q47XwCguLFj giiDqrBwl7mLosk29DdXz2c= =5UPY -----END PGP SIGNATURE----- --Signature_Mon__7_Nov_2005_20_41_25_+0100_chNo7c2eDknqNDQr-- -- gentoo-user@gentoo.org mailing list