AzerothCore
Pages :

MySQL Types C++

Mapping from types used in SQL queries

MySQL type

Core type Example code Variable operators
BIGINT int64 int64 val = fields[n].GetInt64(); %I64d       (Capital i)
BIGINT UNSIGNED uint64 uint64 val = fields[n].GetUInt64(); %I64u       (Capital i)
INT int32 int32 val = fields[n].GetInt32(); %u
INT UNSIGNED uint32 uint32 val = fields[n].GetUInt32(); %u
MEDIUMINT int32 int32 val = fields[n].GetInt32(); %u
MEDIUMINT UNSIGNED uint32 uint32 val = fields[n].GetUInt32(); %u
SMALLINT int16 int16 val = fields[n].GetInt16();  
SMALLINT UNSIGNED uint16 uint16 val = fields[n].GetUInt16();  
TINYINT int8 int16 val = fields[n].GetInt16();  
TINYINT UNSIGNED uint8 uint8 val = fields[n].GetUInt8();  
FLOAT float float val = fields[n].GetFLOAT();  
FLOAT UNSIGNED  
DOUBLE double double val = fields[n].GetDouble();  
DOUBLE UNSIGNED  
text

string (std::string)

or

cstring (char const*)

std::string text = fields[n].GetString();

char const* text = fields[n].GetCString();

 %s
longtext %s
tinytext %s
char(k) %s
VARCHAR(k) %s
blob %s
COUNT(x) uint64 uint64 count = fields[n].GetUInt64(); %UI64FMT*
MAX(x) uint32 or int32

uint32 minmax = fields[n].GetUInt32();

int32 minmax = fields[n].GetInt32();

 %u
MIN(x) %u
SUM(x)

string (std::string)

or

cstring (char const*)

INT sum;

if (const char* ch = fields[n].GetCString())

sum = atoi(ch);

%s

 

%s
UNIX_TIMESTAMP(x) uint64 uint64 unix_time = fields[n].GetUInt64();

 

1* %UI64FMT does not work with acore_string

 

 

Example
// world database query                           0      1      2      3        4
QueryResult result = WorldDatabase.Query("SELECT guid, entry, name, period, ScriptName FROM transports");
do
{
    Field* fields    = result->Fetch();
    uint32 lowguid   = fields[0].GetUInt32();
    uint32 entry     = fields[1].GetUInt32();
    std::string name = fields[2].GetString();
    uint32 period    = fields[3].GetUInt32();
    uint32 scriptId  = sObjectMgr->GetScriptId(fields[4].GetCString());
     
    // ...
}
while (result->NextRow());