[Sanjay Singh]

When I use MySQL to insert the name in a table , its unable to store character as it is instead it shows something weird character.
I have tried NVARCHAR didn't worked.

How to fix this issue?
In MySQL Table : SkY＃IN

[Airkish]

SQL_SetCharset(g_SqlTuple,"utf8");

[Sanjay Singh]

Originally Posted by Airkish SQL_SetCharset(g_SqlTuple,"utf8");

where to use this code?

[Bugsy]

I just ran a test using SQLite and had no issues

'INSERT INTO tblPlayerData (PlayerName) VALUES ('SkY#IN');'

Show me your SQL statement. Also, try what Airkish suggested, place that line after 'g_SqlTuple = SQL_MakeDbTuple()'

[Sanjay Singh]

Originally Posted by Bugsy I just ran a test using SQLite and had no issues 'INSERT INTO tblPlayerData (PlayerName) VALUES ('SkY#IN');' Show me your SQL statement. Also, try what Airkish suggested, place that line after 'g_SqlTuple = SQL_MakeDbTuple()'

idk i used above SQL charset command and now i can see that character in phpmyadmin table but not able to get that character in Website Stats.

[Bugsy]

Not sure how to help you with that as it's likely not AMX-X related.

[Sanjay Singh]

Originally Posted by Bugsy I just ran a test using SQLite and had no issues 'INSERT INTO tblPlayerData (PlayerName) VALUES ('SkY#IN');' Show me your SQL statement. Also, try what Airkish suggested, place that line after 'g_SqlTuple = SQL_MakeDbTuple()'

Edit: I have fixed website stats but

only 1 time i have to add this line before connection or every time ? :"SQL_SetCharset(g_SqlTuple,"utf8");"

[Bugsy]

You should only create the tuple one time in your plugin, in plugin_init() or plugin_cfg(), so you only need to call the SetCharset() once as well.

[Sanjay Singh]

Originally Posted by Bugsy You should only create the tuple one time in your plugin, in plugin_init() or plugin_cfg(), so you only need to call the SetCharset() once as well.

ok thanks buddy solved all my issues

[Bugsy]

No problem, chief.