[L4D] PounceRecord 1.1 - Page 3

n0limit · 08-03-2009 , 14:34 Re: [L4D] PounceRecord 1.1

Guys, try setting the pouncer and pounced column's charset to utf8, which is the default for the game.
They're on latin1 by default, which I think causes the problem.
If that still doesn't work, I can try to set it from inside the SP.

fpsbrian · 08-03-2009 , 23:42 Re: [L4D] PounceRecord 1.1

Of coarse I don't get this, I'm sorry can please explain in noob terms?

Whosat · 08-04-2009 , 02:57 Re: [L4D] PounceRecord 1.1

He's saying change the charset in your MySQL table in which the pouncerecord dbs/tables are found. Change the columns which records the pouncer and pounced names to charset UTF-8. The charset encoding is Latin1 by default, which does not recognize those weird characters.

Go ask your web provider to do it if you completely didn't get what I said.

fpsbrian · 08-04-2009 , 15:03 Re: [L4D] PounceRecord 1.1

I'm sorry it's still not displaying correctly...
Even if I edit the table, it shows question marks
for the special characters.

crazydog · 08-04-2009 , 15:42 Re: [L4D] PounceRecord 1.1

Yeah, I've tried all kinds of encodings on the tables, and no luck with the special characters.

For one of my plugins, I have the table set to utf8_unicode_ci, and as you can see here, it doesn't work how we want it to.

Whosat · 08-04-2009 , 17:36 Re: [L4D] PounceRecord 1.1

The players will have to re-join the server I think

crazydog · 08-05-2009 , 01:21 Re: [L4D] PounceRecord 1.1

Quote:

Originally Posted by Whosat

The players will have to re-join the server I think

I changed that table's encoding a few weeks ago, and that is data starting from just yesterday.

Got the answer: http://forums.alliedmods.net/showthread.php?t=99408

n0limit · 08-05-2009 , 13:39 Re: [L4D] PounceRecord 1.1

Quote:

Originally Posted by crazydog

I changed that table's encoding a few weeks ago, and that is data starting from just yesterday.

Got the answer: http://forums.alliedmods.net/showthread.php?t=99408

Well, thanks for doing the legwork for me. I'll add that command to the plugin as well on the next update.

crazydog · 08-05-2009 , 16:05 Re: [L4D] PounceRecord 1.1

I needed it for my own plugin too. No worries!

n0limit · 08-05-2009 , 16:57 Re: [L4D] PounceRecord 1.1

I don't have a chance to test this, so could one of you guys? I'd be most indebted

I just added

Quote:

if(hDb == INVALID_HANDLE)
LogError("Unable to connect to the specified host for the database configuration named %s.",configName);
else
SQL_TQuery(hDb,SqlPounceCallback,"SET NAMES 'utf8'");