The SQL direct component has not been used because of coding, port problems, but it has been tested successfully.
DatabaseName = ' TEST '
Params.strings = (
' User Name=root '//username
' password=1234567 '//password
' SERVER port=3307 '//Port settings
' Database Name=test '//DB name
' SQL dialect=3 '
' Single connection=true '
' LOCAL Charset=utf8 '//Character Set
' UNICODE string=true ')
Remotedatabase = ' 192.168.1.3 '//server settings most perverted here
ServerType = Stmysql
sessionname = ' Default '
Onlogin = Databaselogin
In addition to the above settings, use SQL to manipulate the database, but also to transcode themselves:
Qryquery.close;
QryQuery.SQL.Text: = Utf8encode (' UPDATE test_person SET note= ' kam 123456 '); To transcode when there are kanji
Qryquery.execsql;
It's really some kind of pervert!
SQL Direct Connection Database parameter settings