how to set charset utf8

[gunsluo]

connection string -> tcp:127.0.0.1:3306*nt_financial/root/jxcec0okm ?

tcp:127.0.0.1:3306*nt_financial/root/jxcec0okm?charset=utf8

[gunsluo]

godrv.Register("SET NAMES utf8")

// Create a connection handler
db, err := sql.Open("mymysql", "test/testuser/TestPasswd9")
checkErr(err)

failed..

[ziutek]

godrv registers "SET NAMES utf8" by default (see Example 7). What do you mean by very descriptive "failed"?

[leeningli]

db, err := sql.Open("mymysql", conn)
sql := select * from test;
rows, err := db.Query(sql)
there is no garbled.
but use:db := mysql.New("tcp", "", url, user, pwd, dbname) ,there is garbled

[ziutek]

Try:

db.Query("SET NAMES utf8")