Character set mysql update

[gjniewenhuijse]

Hello, i try to update a mysql table with character set  utf8_general_ci

Here my code

Code:

1234567891011

require('luasql.mysql') env = luasql.mysql() dbcon = env:connect('xxx','xxx', 'xxx', 'xxx', '3306') if dbcon then     isql = "update table set locatie='Résidentie Bâte Kolères' where villanr = 1"     log(isql)     cursor = dbcon:execute(isql)     dbcon:close()     env:close() end  

 But after updating the table, my locatie column is displayed as: RÃsidentie Bâte Koleères

How to do a correct update? or do i change my character set of the table?

[admin]

Try executing SET NAMES utf8 query before doing any other queries.

[gjniewenhuijse]

Try executing SET NAMES utf8 query before doing any other queries.

Great, that works