Tuesday, June 23, 2015
hi, Fred
On Tuesday, June 23, 2015 at 8:13:13 PM UTC+8, Frederick Cheung wrote:
-- Thank you very much!
Now it works fine!
Because ruby 1.9 does not use utf-8 as default encode:
1.9.3-p551 :001 > __ENCODING__.name
=> "US-ASCII"
For UTF-8, I used the following commands:
bash-3.2$ export LANG=en_US.UTF-8
bash-3.2$ rails c
Loading development environment (Rails 3.2.22)
1.9.3-p551 :001 > __ENCODING__.name
=> "UTF-8"
After that, I get the right record when I run the previous query:
1.9.3-p551 :002 > ActivityObject.where(:title => '第一个纵纹')
ActivityObject Load (29.5ms) SELECT "activity_objects".* FROM "activity_objects" WHERE "activity_objects"."title" = '第一个纵纹'
=> [#<ActivityObject id: 648, created_at: "2015-06-21 14:41:19", updated_at: "2015-06-21 14:41:19", object_type: "Excursion", like_count: 0, title: "第一个纵纹", description: "整的行不？", follower_count: 1, visit_count: 5, language: "independent", age_min: 0, age_max: 0, notified_after_draft: false, comment_count: 0, popularity: 0, download_count: 0, qscore: 500000, reviewers_qscore: nil, users_qscore: nil, ranking: 0, title_length: 1, desc_length: 1, tags_length: 1, scope: 0, avatar_file_name: nil, avatar_content_type: nil, avatar_file_size: nil, avatar_updated_at: nil, teachers_qscore: nil>]
On Tuesday, June 23, 2015 at 3:02:36 PM UTC+3, Dillon Peng wrote:
> Also, I can directly query this record using the Chinese string under psql:
> vish_development=# select * from activity_objects where title = '第一个纵纹';
> So my question is that what should I do for enabling CJK string in ActiveRecord's where or like this?
I'm not aware of any rails setting that controls this, however there are a few things that could come into play:
- what is the encoding of that string? Current versions of ruby default to Utf-8, but I don't think 1.9 did
- what are postgres' collation / encoding settings ? This will affect how strings are compared, which is super important in unicode, with different normalisation forms and so on.
Fred
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/4e7a5007-1a6f-4cdb-897f-6f6cf294c9f7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment