I'm starting to use VFP5 via ODBC to MySQL.
MySQL is in ISO8859_1 (Latin1), VFP use codepage 1250.
After command:
pnHandle=SqlConnect(..MySQLdatasource ..)
I execute MySQL command:
=SqlExecute(pnHandle,"set character set cp1250_latin2")
and all characters in this pnHandle are right.
But,
if I use views - not.
I found ways (but I don't like them):
1)
use MyViewName nodata
=SqlExecute(EstimateHandle,"set character set cp1250_latin2")
requery()
2)
use FalseView
=SqlExecute(EstimateHandle,"set character set cp1250_latin2")
use MyViewName

but where is problem with the EstimateHandle (it isn't solid).

Is any other method ?

Thanks
Pavel