This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.

Character set mysql update
#1
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?
Reply


Messages In This Thread
Character set mysql update - by gjniewenhuijse - 04.12.2023, 19:58
RE: Character set mysql update - by admin - 05.12.2023, 08:29

Forum Jump: