[MySQL] Bigint as string

Starbish · **Author**

is it possible to get "bigint" typed column value as string in sourcemod?

like... getting "SteamID64 bigint" column with SQL_FetchString().

Impact123 · 11-18-2015 , 04:29 Re: [MySQL] Bigint as string

Yes.

Kailo · 11-18-2015 , 04:37 Re: [MySQL] Bigint as string

if table name `table` and line have field `id` = 1 and field `steamid` as bigint, ur code will be

PHP Code:


			
"SELECT CONVERT(`steamid`, char) FROM `table` WHERE `id` = 1;"

asherkin · 11-18-2015 , 04:41 Re: [MySQL] Bigint as string

Quote:

Originally Posted by Kailo

if table name `table` and line have field `id` = 1 and field `steamid` as bigint, ur code will be

PHP Code:


			
"SELECT CONVERT(`steamid`, char) FROM `table` WHERE `id` = 1;"

SQL_FetchString should just work.

Starbish · 11-18-2015 , 05:45 Re: [MySQL] Bigint as string

Thank you for answering.