# I am sorry about this question,please help me!

**URL:** <https://www.ruby-forum.com/t/i-am-sorry-about-this-question-please-help-me/111903>\
**Category:** Rails\
**Created:** [August 13, 2007, 8:12am UTC](https://www.ruby-forum.com/t/i-am-sorry-about-this-question-please-help-me/111903 "2007-08-13T08:12:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![daociyiyou](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/0ea827/32.png) [@daociyiyou](https://www.ruby-forum.com/u/daociyiyou)\
**Post date:** [August 13, 2007, 8:12am UTC](https://www.ruby-forum.com/t/i-am-sorry-about-this-question-please-help-me/111903/1 "2007-08-13T08:12:14Z")

</div>

```
I use Instant Rails 1.7 to develop this project in windows xp. I

```

have attached it.How can i make it to display in chinese when i input  
“[http://localhost:3000/admin/list](http://localhost:3000/admin/list)” in the browser.  
Thank you!

---

<div class="post-metadata">

**Author:** ![daociyiyou](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/0ea827/32.png) [@daociyiyou](https://www.ruby-forum.com/u/daociyiyou)\
**Post date:** [August 13, 2007, 8:31am UTC](https://www.ruby-forum.com/t/i-am-sorry-about-this-question-please-help-me/111903/2 "2007-08-13T08:31:10Z")

</div>

Guo Y. wrote:

> ```
> I use Instant Rails 1.7 to develop this project in windows xp. I
> 
> ```
> 
> have attached it.How can i make it to display in chinese when i input  
> “[http://localhost:3000/admin/list](http://localhost:3000/admin/list)” in the browser.  
> Thank you!
> 
> Attachments:  
> [http://www.ruby-forum.com/attachment/105/cashmere.rar](http://www.ruby-forum.com/attachment/105/cashmere.rar)

See my reply to your other thread here:

[http://www.ruby-forum.com/topic/121287#541357](http://www.ruby-forum.com/topic/121287#541357)

–  
Michael W.

---

<div class="post-metadata">

**Author:** ![daociyiyou](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/0ea827/32.png) [@daociyiyou](https://www.ruby-forum.com/u/daociyiyou)\
**Post date:** [August 13, 2007, 10:03am UTC](https://www.ruby-forum.com/t/i-am-sorry-about-this-question-please-help-me/111903/3 "2007-08-13T10:03:17Z")

</div>

Thank you!When i use command “show create database  
\<database\_name\>”,the console window show that database’s coding is  
“latin1”.Later I added line "encoding: utf8"in my  
database.yml,remigrated my three migrations,then console window said:

# D:\ruby\cashmere\>rake db:migrate VERSION=0 (in D:/ruby/cashmere) == AddTestData: reverting

# == AddTestData: reverted (0.1400s)

# == AddPrice: reverting

# – remove\_column(:products, :price) → 0.1870s == AddPrice: reverted (0.1870s)

# == CreateProducts: reverting

# – drop\_table(:products) → 0.0470s == CreateProducts: reverted (0.0470s)

# D:\ruby\cashmere\>rake db:migrate (in D:/ruby/cashmere) == CreateProducts: migrating

# – create\_table(:products) → 0.0930s == CreateProducts: migrated (0.0930s)

# == AddPrice: migrating

# – add\_column(:products, :price, :integer, {:default=\>0}) → 0.1250s == AddPrice: migrated (0.1250s)

# == AddTestData: migrating

rake aborted!  
Mysql::Error: Illegal mix of collations (latin1\_swedish\_ci,IMPLICIT) and  
(utf8\_g  
eneral\_ci,COERCIBLE) for operation ‘=’: SELECT \* FROM products WHERE  
(products.t  
itle = ‘白领男’) LIMIT 1

```
 This shows mysql setting is not right.How can i manage it?I am a 

```

fresher to mysql.

Michael W. wrote:

> Guo Y. wrote:
> 
> > ```
> > I use Instant Rails 1.7 to develop this project in windows xp. I
> > 
> > ```
> > 
> > have attached it.How can i make it to display in chinese when i input  
> > “[http://localhost:3000/admin/list](http://localhost:3000/admin/list)” in the browser.  
> > Thank you!
> > 
> > Attachments:  
> > [http://www.ruby-forum.com/attachment/105/cashmere.rar](http://www.ruby-forum.com/attachment/105/cashmere.rar)
> 
> See my reply to your other thread here:
> 
> [About chinese display - Rails - Ruby-Forum](http://www.ruby-forum.com/topic/121287#541357)
> 
> –  
> Michael W.