Language question

[najaru]

Hi guys

2 question about the language translation in italian

1-can i use normally the letters ò à è ì ù? i ask this because in my forum i see all letters normally, but some admin that have install my translation see à and not à ......... what is the problem?

2- are There rules to follow when i set Language Locale in ACP? normally italian is it_IT ....and i have set it_ITA .....may create problems?

thanks

Edytowane 23 Czerwca 2010 przez najaru

[DawPi]

Ad 1 - what is your database and tables charset? You can check this easilly in PhpMyAdmin.

I think this depends also from theirs charsets in browsers.. Must be investigated deeper by you and them.

Ad 2 - Where you find this it_ITA locale type?

[najaru]

ad2: i dont have find this, i have set it so.... just to change

it's a problem?

[DawPi]

Set it_IT.UTF-8 or other charset if you have DB in different chars..

[najaru]

how can i explain at my user the best method to change the charset in mysql?

[DawPi]

Nope! User can't change anything in ... sql? Who sql?

Well.. Try ask him about their browsers and charsters sets there..

[najaru]

no no sorry

my user are all admins of forum based on ipb board

but as me, it dont know how to change charset in its databases

[DawPi]

They don't have databases.. Database have only you.

I mean charsets in their browsers ( Firefox, Opera etc. ).

[najaru]

no DawPi.

they have a database, because each of him is an admin of forum (based on ipboard)

for example a user have installed my italian translation in his forum, but he dont see the character in his forum (not mine forum) correctly like me in my forum

i have find this:

ALTER DATABASE name_db CHARACTER SET=utf8;
ALTER TABLE name_table CHARACTER SET=utf8;

but is good?

hot to convert all database with only one query?

[DawPi]

Eh...

[Miranda]

Well, if you changed the charset after installation of the forum with threads / posts created you will have MANY problems with the exchange of Charset, then I recommend changing the charset only after the installation of the forum before creating forums and release records .

to change is simple, go to the search bar and search for CHARSET on the AdminCP and change to ISO-8859-1 if it is to recognize special accents.