Hi,

I have been surprised to see that all special caracters are encoded in the database, that's not handy if you want to open your roster data to an other application.
So I am trying to find the function to make the conversion, but I do not find anything because I can't even figure out what kind of encoding it is. I does not seems to be done in the database table, but rather before when the records are inserted.
I'll probably find a way to do it but since there's already 2 hours that I am searching, I rather prefear to ask you all and switch to others things until I got a reply

Here's what I want to do:
My nickname, for instance, is Aränel.
In the members table, its encoded as Aränel
When I query my base like this

Code: Select all

SELECT * FROM `WoW_members` WHERE `name`='Aränel'

it don't find the record.
So I need the PHP function to convert all special characters in my query fields before trigger it.

Txs for lighting me

You need utf8_decode.

The data in roster is utf8 everwhere, but the character set in the database doesn't reflect that. Which causes those errors.

We're not taking the risk of switching it around in the 1x branch, also because of compatibility. R2 will use utf8 DB tables by default.

You wrong I needed utf8_encode

Tank you very much that's working like a charm

...I always get those two functions mixed up

Damn you're right, didn't read your post correctly.

I'm also having some trouble with the encoding.

I have a toon in the database under the name of: Übershammy
The database has this stored as: Ãœbershammy

This is how I'm trying to retreave the information:

Code: Select all

echo $res['name']."<br />\n";
echo utf8_decode($res['name'])."<br />\n";
echo utf8_encode($res['name'])."<br />\n";

and this is what I get

Code: Select all

Ãœbershammy
Ã?bershammy
Ãœbershammy

When the page header is set to the ISO-8859-1 character set and

Code: Select all

Ãœbershammy
�?bershammy
Ãœbershammy

under UTF-8.

Any ideas on what I'm doing wrong?

Are you using the header() function to set the encoding on the page?

I am
{edit}
This is what I have been using, I believe it to be right

header('Content-Type: text/html; charset=ISO-8859-1');
header('Content-Type: text/html; charset=UTF-8');

I just tried the same thing
Here is what I got

Code: Select all

$text = 'Ãœbershammy';

header('Content-Type: text/html; charset=iso-8859-1');

echo $text."<br />\n";
echo utf8_decode($text)."<br />\n";
echo utf8_encode($text)."<br />\n"; 

And this was the result

Code: Select all

Ãœbershammy
Übershammy
Übershammy

Weird, doesn't work on my development server, works on my live server.

Sorry for wasting your time

No, it's ok
Better to learn than to not know at all right?

probably an option to change in your php.ini to make it working locally

Could anyone point me out what to change in order to display members with special character names correctly on all roster pages ?

I have PHP version 5+ on my server.

Thx

i've got some similar problem, in the DB the character apears with the special characters but in the roster they are ok ... from what i've notive the characterprofile.lua file had this same problem.

I've notice that after instaled the sysnc phpbb grp's with the roster character info, and when i was checking the DB i changed some names but when i update the characterprofile.lua again i get the same problems with the names ...

TKS

well im having the same issue in my 1.7.3 roster having a character with some unusual character in his name and the roster's home page even show me a bug"Vodk�" instead of "Vodkà" doesnt seems like the probleme has been solved, if ther a way to check it up again :p