Modules/MTA-MySQL/mysql set character set: Difference between revisions

From Multi Theft Auto: Wiki
Jump to navigation Jump to search
(New page: __NOTOC__ Changes the character set used for the current MySQL session. ==Syntax== <syntaxhighlight lang="lua"> bool mysql_set_character_set ( MySQLConnection handler, string charset_name ) </syntaxhighlight> ===R...)
 
No edit summary
Line 1: Line 1:
__NOTOC__
__NOTOC__
{{ModuleFunction|MTA-MySQL}}
Changes the character set used for the current MySQL session.
Changes the character set used for the current MySQL session.



Revision as of 18:02, 14 January 2008


Package-x-generic.png This function is provided by the external module MTA-MySQL. You must install this module to use this function.

Changes the character set used for the current MySQL session.

Syntax

bool mysql_set_character_set ( MySQLConnection handler, string charset_name )

Required arguments

  • handler: A valid MySQL link
  • charset_name: The new character set name

Returns

It it succeeds returns true, in other case returns false.

Example

Example 1:

handler = mysql_connect("localhost", "user", "password", "mta_users")
if (not handler) then
  outputDebugString("Unable to connect to the MySQL server")
elseif (not mysql_set_character_set(handler, "utf8")) then -- Change the charset to UTF-8
  outputDebugString("Unable to change the connection character set to utf8: ("
                    .. mysql_errno(handler) .. ")" .. mysql_error(handler))
  mysql_close(handler) -- Close the connection afther the error
end

See also