Character set mysql update

[gjniewenhuijse]

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

Here my code

Code:

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