General information
Title:
Problems with character set
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only