Fetch data From Mysql using ruby

Question

My code is this

db_con =Mysql.new('localhost', 'root', 'root', 'user')
obj = db_con.query("select * from users where id=1 limit 1")
title=obj.fetch_hash["title"]

it gives result but my title is in Russian language e.g(знак ударения, znak udareniya) it gives us

title =???? ????????, znak udareniya

in my db it stored ,знак ударения, znak udareniya

how can i solve this problem please suggest me

Have you got '# encoding: utf-8' at the beginning of your file? — ted
– ted, Commented Apr 12, 2013 at 7:40
if you use rails dbconsole select * users where id = 1, does the name show correctly? — Smar
– Smar, Commented Apr 12, 2013 at 7:51

user1645023 · Accepted Answer · 2013-04-12 12:21:58Z

2

You use

 db_con =Mysql.new('localhost', 'root', 'root', 'user')
    db_con.query("set names utf8")
    obj = db_con.query("select * from users where id=1 limit 1")
    title=obj.fetch_hash["title"]

and i found original results

answered Apr 12, 2013 at 12:21

user1645023

Sign up to request clarification or add additional context in comments.

Comments

Stan K. · Accepted Answer · 2013-04-12 07:46:37Z

0

Change your encoding in DB to utf8 or create a new db:

$ mysql -u USER -p
create database YOURDB_NAME_development CHARACTER SET utf8 COLLATE utf8_general_ci;

answered Apr 12, 2013 at 7:46

Stan K.

4872 silver badges11 bronze badges

Collectives™ on Stack Overflow

Fetch data From Mysql using ruby

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related