Differn't languages

[chesney-93]

Hello, two of my testers speak another language as well as English, they speak Icelandic.

There is about 6 special letters they use, when they do use them they don't appear as they should, instead  a � appears and the chat breaks in IE because of this. How do I add these letters so they work just like abc?

Thanks for reading!

[Chris]

Charset (preferably UTF-8). Also, the user has to have a proper font installed in the system (so no matter what you do majority won't see Chinese language because they don't have it installed in the system, but it should not be a problem for latin languages).

[BlackScorp]

use in your HTML header

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

use in your php files

header("Content-Type: text/html; charset=utf-8");

use after database connection

mysql_query("SET NAMES 'utf8' ");

so you can display ALL languages

[chesney-93]

Thank you guys, worked fine :-)

I also have another quick question, whole this topic is active I'll post here..

Because I've made this chat out of PHP/AJAX most im just using a normal <input for the text, after awhile when typing you see past messages show up (history for that input) how would I make it so its unique every time? I guess its adding a hash or something to it? :S

[Chris]

use after database connection

mysql_query("SET NAMES 'utf8' ");

What's that and what it does? Never seen it...

so you can display ALL languages

The user still needs to have the font installed. Also proper locale (some languages are right to left instead left to right).

You also need proper locale installed on the server.

Generally, the problem becomes more escalated for multibyte languages (like strlen() and other functions not working). It's best to focus on latin only languages, much simplier than ALL languages and does not require rewriting of the code.

[BlackScorp]

use after database connection

mysql_query("SET NAMES 'utf8' ");

What's that and what it does? Never seen it...

this set ur Database to UTF8 so you can save chinese, arabian, russian words into your database

i had some names in my databse like this محمد ابو علي the funny think is that the browsers displays it from right to left automaticly


its simpler to manage latin characters only.. but its boring you know..

[Chris]

What you mean by "this set ur Database to UTF8"? What it does with "CHAR(16)" field for example?

its simpler to manage latin characters only.. but its boring you know..

LOL, boring!? I'm doing it right now, it is not boring at all, rather challenging (don't forget about all these additional things like staff support, players communication, identification and representation of language used by fellow players, changes in social groups caused by language barriers; the display of different languages is merely a tiny part of it)

[chesney-93]

What you mean by "this set ur Database to UTF8"? What it does with "CHAR(16)" field for example?

its simpler to manage latin characters only.. but its boring you know..

LOL, boring!? I'm doing it right now, it is not boring at all, rather challenging (don't forget about all these additional things like staff support, players communication, identification and representation of language used by fellow players, changes in social groups caused by language barriers; the display of different languages is merely a tiny part of it)

True, what are the chances of people using that languages signing up to a game in english?

[BlackScorp]

i got those names from my Facebook plugin.. you know Facebook API gives u the Names from users in the language which they using.. i got some chinese names in my DB as well. if you add facebook login in our game, a new user could have those characters i dont know if you can safe it in your database with latin ...

anyways iam using only UTF8 because everyone do this:P
BTW Chriz read this http://dev.mysql.com/doc/refman/5.0/en/charset.html