search

weigj / go-odbc

ODBC Driver for Go language
Other
122 stars 49 forks source link

查询MSSQL GUID截断问题 #19

Open forrestsun opened 9 years ago

forrestsun commented 9 years ago 
conn, _ := odbc.Connect(connstr)
    sql := "select CLASS_ID,CLASS_NAME from COMM_RES_CLASS where CLASS_PID='" + media_guid + "' order by CREATE_TIME"
    stmt, _ := conn.Prepare(sql)
    stmt.Execute()
    rows, _ := stmt.FetchAll()
    stmt.Close()
    for _, row := range rows {
        fmt.Println(row.GetString(0))
    }

    conn.Close()

结果中的36位guid编码被截断了，请问如何处理？

shawnye commented 7 years ago

你看看 COMM_RES_CLASS 定义 CLASS_ID 是不是小于36*2=72个字符, 建议定义为 varchar(72)或更大,这似乎是go-odbc的bug