[+ARUKARI-]

Does SQLX's SQL_ReadResult function not support UTF8?
Specifying utf8 in SQL_SetCharset does not apply to SQL_ReadResult.

If there is a way to get a multi-byte string in SQL, please let me know.

[JocAnis]

i have been using utf8mb4 for sql_setcharset and had no problems with database...maybe try that change and test?

[+ARUKARI-]

I'm trying to output the Japanese stored in sqlite to the screen now.
There is no problem with DB, but the string read by SQL_ReadResult is garbled.
I think it is SQL_ReadResult that has a problem because I confirmed that client_print and hudmessage can display Japanese.

[Bugsy]

Are you able to see if any data is stored outside of the first byte with the UTF8 characters in your string?

Example:

PHP Code:

new szTest[] = "A";

server_print( "[%d][%d][%d][%d]" , szTest{0} , szTest{1} , szTest{2} , szTest{3} ); 


Output:

[0][0][0][65]

[+ARUKARI-]

The resulting output looked like this.

[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][129]
[DEBUG]: [0][0][0][147]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][130]
[DEBUG]: [0][0][0][147]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][129]
[DEBUG]: [0][0][0][171]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][129]
[DEBUG]: [0][0][0][161]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][129]
[DEBUG]: [0][0][0][175]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][128]
[DEBUG]: [0][0][0][129]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][131]
[DEBUG]: [0][0][0][150]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][131]
[DEBUG]: [0][0][0][169]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][131]
[DEBUG]: [0][0][0][131]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][130]
[DEBUG]: [0][0][0][175]
[DEBUG]: [0][0][0][227]
[DEBUG]: [0][0][0][131]

Well, perhaps this is how it is?
UTF8 (3byte)

[[227][129][147]], [[227][130][147]], ...
0xE3 81 93 = こ,  0xE3 82 93 = ん

[+ARUKARI-]

I was mistaken.
Close this thread, as client_print outputs no problem.
The garbled text only occurs with HL's HudMessage, so the cause seems to be on the HudMessage side.

https://github.com/ValveSoftware/halflife/issues/515

[peaces]

If read UTF-8 characters from the database, it seems that the characters cannot be displayed normally in the game.
Is there a solution? thanks.

[Bugsy]

Show the code and output you are getting.

[+ARUKARI-]

And what game are you trying to do it with?
It was HL1 that I had a problem with.

[peaces]

Originally Posted by Bugsy Show the code and output you are getting.

Originally Posted by +ARUKARI- And what game are you trying to do it with? It was HL1 that I had a problem with.

new str[32]
			SQL_ReadResult(query, 0, str, 31)
	
			if(get_pcvar_num(pi_show_who) == 1)
			{
				new players[32], playersnum
				get_players(players, playersnum, "ch")
				for(new i = 0; i < playersnum; i++)
				{
					new player = players[i]
					if(is_user_admin(player))
					{
						if(get_pcvar_num(pi_hudmsg) == 0)
						{
							client_print(player, print_chat, "%L", LANG_PLAYER, "JOIN_MSG", name)
							client_print(player, print_chat, "%L", LANG_PLAYER, "JOIN_MSG2", str)
						}
						else
						{
							new message[192]
							format(message, 191, "%L", LANG_PLAYER, "JOIN_HUDMSG", name , str)
							set_hudmessage(0, 255, 0, 0.05, 0.30, 0, 6.0, 5.0 , 0.5, 0.15, -1)
							ShowSyncHudMsg(player, MyMsgSync, "%s", message)
						}
					}
				}
			}

SQL_ReadResult
If read UTF-8 characters from the database, it seems that the characters cannot be displayed normally in the cstrike