[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[bjlug-ml] Re: Re: MySQLãæååã
- To: bjlug-ml@xxxxxxxxx
- Subject: [bjlug-ml] Re: Re: MySQLãæååã
- From: "Daigo Fujiwara" <redsox51@xxxxxxxxx>
- Date: Thu, 2 Mar 2006 17:21:02 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=pk/ox6ZOgjK1NqYcFh9t9tJiENjb3EPhKLGHDI9mcMAbS8GAbRMbuvil5GqGlEKXUL1LLXl67ubuCmt8RvbL6NVO+Xyu34VYdTJIbq8Se20Zs5MlTRkTMn1L11Cst0Rfn3+J2x2udRfJLk28iKgSuVaADc9mBkceRNtTnMlZI98=
- In-reply-to: <63e048780602272212q2248c3c3r455303731f42b04d@mail.gmail.com>
- List-help: <mailto:bjlug-ml-ctl@bjlug.org?body=help>
- List-id: bjlug-ml.bjlug.org
- List-owner: <mailto:bjlug-ml-admin@bjlug.org>
- List-post: <mailto:bjlug-ml@bjlug.org>
- List-software: fml [fml 4.0.3 release (20011202/4.0.3)]
- List-unsubscribe: <mailto:bjlug-ml-ctl@bjlug.org?body=unsubscribe>
- References: <C22F52BD-13E7-4D2B-BF33-2F1385D6FD53@daigofujiwara.com> <44034153.1000604@smartfruit.com> <63e048780602272212q2248c3c3r455303731f42b04d@mail.gmail.com>
- Reply-to: bjlug-ml@xxxxxxxxx
ããåéãããããããããããã
âdefault-character-set=latin1
ãããããããäããããèæããããããèããçãããäãèåãããããæããããããèãããããããããïããããèãããããããï
http://daigo.org/index.php/archives/2006/03/02/mysql-turncated-japanese-update/
ããããmixiããããäbjlugããåãããïããããããããããããããããããäããããããèããããããããã
ããããããããããåäãããããããã
ããã
On 2/28/06, Daigo Fujiwara <redsox51@xxxxxxxxx> wrote:
> Taiãã
> ãããããããããããçämysqldump ãããããããããã
> http://www.siliconvalleyccie.com/linux-adv/mysql.htm
> ããããããéåãåãçããããã
>
> ããããããæãããããDNSãçããããããããèäããããããããããããïïï
>
> éåãèçããããããããåãããããããããããã
> DNSãååãæçæéèããååãããã
>
> ããããããããããããããäããããããããããããããããããããããï
>
>
> åæ
> ïããããããããããåäãããããããïï
>
>
>
> On 2/27/06, Naoyuki Tai <ntai@xxxxxxxxxxxxxx> wrote:
> > Daigo Fujiwara wrote:
> >
> > >
> > > ãããããæçãããæååããèããããããããããããããã
> >
> > åãèããããããããããæåã
> >
> > INSERT INTO `wp_comments` VALUES (2, 3, 'MasatoÂÃÅÃÃÃÅÃÃÃUjigawa'
> >
> > ããããã
> > Masato ã Ujigawa ãéã
> >
> > c3 a3 e2 82 ac e2 82 ac
> >
> > ããããããããäãããããããæåã iso-8859-1 ãã utf-8 ããåæã
> > èãããã
> > ããæãããããããããããããïãããããããæãããããããïããã
> > ããããã
> > ããããèãããããã
> >
> > 'c3 a3'
> > 'e2 82 ac'
> > 'e2 82 ac'
> >
> > ããããããããããããæããããã
> > ãã e2 82 ac ã utf-8 ãã euro symbol ãã Windows code page 1252 ããã
> > ããããããã 80 ããããããããããããããããããããããããåã
> > ãããã
> >
> > e3: c3 a3
> > 80: e2 82 ac
> > 80: e2 82 ac
> >
> > ããã Unicode/utf-8 ããããã ãã Windows-1252 ãããããããåå
> > utf-8 ã
> > åæããããããããããææãããããã
> >
> > éåæãããã
> >
> > iconv -f utf-8 -t windows-1252 foo.sql > bar.sql
> >
> > ãçæãäéãåãæããããããããèãããããããã
> > äããããããããããæéãåãããããããääãèæãããããã
> >
> > ãããããã phpMyAdmin ãäãããããçæ mysqldump ãããããäããã
> > dump ããããããããããåãããããããã phpMyAdmin ãããããããã
> > utf-8 ããæããããããããååãutf-8 ãæåãããããããããããåæ
> > ãèããããããutf-8 ãæåãããããããççã mysql ããããããã
> > ããããããããããããããåãããæããããããã
> > dump ããããã AIM ãããããããçæããããäääãåãããããåã
> > éèãããããããããããããã
> >
> > --
> > +--+--+ | | --+-- -- Peace on Earth
> > | | | -+--+- +-+ ---
> > +--+--+ --+--+-- | |=| /
> > | | | | | | +-+ / Naoyuki "Tai" Tai
> > +--+--+ _| +----- ------ ntai a t smartfruit d o t com
> >
> >
> >
> >
>
>
>
> --
> Daigo Fujiwara
> daigo@xxxxxxxxxxxxxxxxx
>
> http://www.go-redsox.com/
> http://www.japaneseballplayers.com/
--
Daigo Fujiwara
daigo@xxxxxxxxxxxxxxxxx
http://www.go-redsox.com/ http://www.japaneseballplayers.com/