[Gambas-user] Characters with ~ or ' not saved correctly in MySQL

[Fabricio Silva]

This is a strange behavior the happens only if I save data in MySQL using
gambas. For example using gambas the word "Goiás" is stored "Goiás" in
database. Using phpmyadmin to insert data the word "Goiás" is saved
correctly. I'm using this code:
     .rs = .db.Exec("insert into employes values( ' " & txtname.text & " ','
" & txtaddress.Text & " ')")

Am I forgeting something that I should tell gambas to do in order to save
data? Or it uses the table definitions?
I'm using SuSE 10.0 - MySQL4.1.13 - Gambas 1.9.35 - Collation of the table
and fields: latin1_swedish_ci


Fabricio
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20060807/5ab3b9ee/attachment.html>