'invalid UTF-8 in string' with mssql using latin1 about odbc HOT 3 CLOSED

I don't understand what your problem is. Please provide some instructions so I 
can try to reproduce your problem here. Marking this issue as Invalid until you 
do.

> Is your module able to decode the data on the fly like 
github.com/go-sql-driver/mysql does?

I don't understand your question. You should be able to use standard utf8 Go 
strings and these will be saved into correspondent MS SQL columns properly. If 
you use non-ascii characters, database columns must be of appropriate type 
(nchar not char and so on).

Alex

The MSSQL database I'm using already has data in latin1. I can't change that.

The column type is varchar(MAX) for the query I'm trying to use. I can't change 
that either.

In python I would only need to connect with the following line and I wouldn't 
need to decode from latin1 (_mssql would do it for me):
conn = _mssql.connect(server='ip', user='user', password='password', 
database=bd, charset='ISO-8859-1')

In go, for mysql with go-mysql I guess it would be (I didn't test it):
"user:pass@tcp(ip:port)/database?charset=latin1"

I hope my example is clear enough. Basically, the data is encoded in latin1 in 
a varchar(max) column and I wish I could tell code.google.com/p/odbc that I 
want the data in UTF-8 when I do Scan().

I don't know if it matters but the database collation is 'French_CI_AS'.

> The MSSQL database I'm using already has data in latin1. ...

If you data is stored in char fields and encoded in latin1, then 
code.google.com/p/odbc won't help you to convert it into utf8. The driver only 
converts ansii in char and utf16 in nchar into Go utf8 strings. You need to use 
some other package to convert latin1 to utf8. Sorry.

Alex