accents in guild names

znog · Post by **znog** » Fri Jan 14, 2005 7:45 pm

there is a problem with accents in guild names, tell me if you need more info, I can help you with the FR names.

Post by **Rollie** » Fri Jan 14, 2005 8:50 pm

Yeah, I'm still tracking this down. I am pretty sure it is an issue with the character set used by either PHP or mysql or both. Might ping you on some issues as I try to get it resolved!

znog · Post by **znog** » Sat Jan 15, 2005 9:15 am

Ok don't hesitate if you need help

for FR you mainly need to fix
? ? ? ? ? ? ? ? ?

and for german things like
?

btw ever though about going into korean / chinese ?

Post by **Rollie** » Sat Jan 15, 2005 10:56 am

znog wrote:btw ever though about going into korean / chinese ?

I have actually gotten some updates in Korean and needless to say there wasn't much I could do with it, haha.

I tried using the Alta Vista babelfish translator but you should have seen some of the translations it would give me. They were actually quite humorous! Maybe I should go dig those up and post 'em for posterity =)

Post by **Rollie** » Sat Jan 15, 2005 2:52 pm

Actually, what I am seeing is that they are correct in the text file, but when I read them in, they are not correct, so I am assuming it has to do with what characterset I have set up in PHP. I'm looking into this as I get time and will hopefully find a resolution soon.

znog · Post by **znog** » Sat Jan 15, 2005 6:18 pm

MadMax-X wrote:The problem might be the same I ran into with german characters like ???.

even on german, euro-english and Us serveurs, you will find alien guilds / character names... not only french but poles, swedes as well.... that means plenty of accents and strange letters.

So it's probably better to handle all kinds of accents on all serveurs.

Post by **Rollie** » Tue Jan 18, 2005 6:51 pm

Well, I have narrowed this down somewhat. I have found that I CAN read the characters just fine, just not when I read them from the SavedVariables.lua file that is sent to the site. I am still working on it though so keep your fingers crossed!

If any of you have experience working with php and multi-byte characters, I'd greatly appreciate some hints or tips!

Post by **Rollie** » Wed Jan 19, 2005 3:35 pm

Well I figured out how to fix this, the only problem is all the current data I have with bad names and such. I am not sure how to go about updating those and as it is, it will create all new CORRECT entries for those characters/guilds that it finds now.

Post by **Rollie** » Wed Jan 19, 2005 6:02 pm

I am updating guilds and character names to display properly. If you find a guild or character name that is not displayed correctly, please let me know!

znog · Post by **znog** » Sat Jan 22, 2005 8:46 am

Rollie wrote:I am updating guilds and character names to display properly. If you find a guild or character name that is not displayed correctly, please let me know!

I checked and apparently everything is absolutely perfect ... bravo !