alexbrainman / odbc

odbc driver written in go
BSD 3-Clause "New" or "Revised" License
359 stars 141 forks source link

The data types nvarchar and text are incompatible in the equal to operator. #48

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
When I use the newest driver, and it will occurred error: The data types 
nvarchar and text are incompatible in the equal to operator. And you can found 
the example from the attach file.

Thank.

Original issue reported on code.google.com by Zuggie....@gmail.com on 1 Sep 2014 at 2:44

Attachments:

GoogleCodeExporter commented 9 years ago

Original comment by Zuggie....@gmail.com on 1 Sep 2014 at 2:57

Attachments:

GoogleCodeExporter commented 9 years ago
What is your OS where your program runs? What odbc driver you use? Thank you.

Alex

Original comment by alex.bra...@gmail.com on 1 Sep 2014 at 4:46

GoogleCodeExporter commented 9 years ago
OS1: windows XP sp3
OS2: windows 2008 server
SQL Server: 2008 R2
https://code.google.com/p/odbc

Original comment by Zuggie....@gmail.com on 1 Sep 2014 at 5:15

GoogleCodeExporter commented 9 years ago
change the test.go import:
/*
import (
    _ "./odbc"
    "database/sql"
    "fmt"
    "reflect"
)
*/
import (
    _ "code.google.com/p/odbc"
    "database/sql"
    "fmt"
    "reflect"
)

Original comment by Zuggie....@gmail.com on 1 Sep 2014 at 5:18

GoogleCodeExporter commented 9 years ago
Zuggie.Zhu,

Please, try this change https://codereview.appspot.com/136070043/ to see, if it 
works for you. Thank you.

Alex

Original comment by alex.bra...@gmail.com on 1 Sep 2014 at 7:09

GoogleCodeExporter commented 9 years ago
Hi Alex,
    Now all things look like well. Thank you.

Original comment by Zuggie....@gmail.com on 1 Sep 2014 at 7:47

GoogleCodeExporter commented 9 years ago
This issue was closed by revision 78314be168c8.

Original comment by alex.bra...@gmail.com on 2 Sep 2014 at 1:28