Russian NickName

[managerlexx]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:3136M
L2JDP Revision Number:6211M

Question for Russian:)
In Gracia Final there was a possibility to create NickName in Russian.

Question:
For me at creation of the character with Russian NickName instead of characters appear - ????????.

How to make so that in game NickName was Russian?

I assume that in the table "Characters" in a column "char_name" it is necessary to put coding UTF8 instead of latin?

Thanks.

[qwerty13]

Try to set utf-8 encoding for your database.
and look this lines in config
CnameTemplate = .*
PetNameTemplate = .*

[managerlexx]

In which table to put coding UTF8?
And in what column?
Or it is necessary to put coding UTF8 to all database?

[Eragon]

My guess is the Character name table in the characters.sql file.

But unsure, on the previous versions of L2, it was only possible with client edits.

[qwerty13]

Or use russian offical client.

[managerlexx]

Matter is not in the game client:)

At input NickName in Russian in a database it is saved in sort- ??????? - Here such characters.

[Evilus]

Try this man

\u0410-\u042f\u0430-\u044f <----Add that where nicks are checked..ie valid names and so on

and in server.properties..

change URL = jdbc:mysql://localhost/l2jdb

to URL = jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=utf-8

[_DS_]

Works for me by just using utf8 for database (and proper client).

[Vapulabe]

I think that putting the DB in UTF-8 could be a good idea anyway.

Java uses Unicode to store strings... And there are other languages that use non-ascii characters (like french : éèêëàùç...), german (the double "s" which looks like greek "beta"), turkish (i without a dot), polish (cedilla under a and e, barred l), ...

[managerlexx]

Try this man

\u0410-\u042f\u0430-\u044f <----Add that where nicks are checked..ie valid names and so on

and in server.properties..

Code: Select all

 ---------------------------------------------------------------------------# Misc Player Settings# ---------------------------------------------------------------------------# Character name template.# Example: CnameTemplate = [A-Z][a-z]{3,3}[A-Za-z0-9]*# The above setting will allow names with first capital letter, next three small letters, and any (capital or not) letter or number, like OmfgWTF1# Most rational to have CnameTemplate = [A-Z][a-z]*# The above setting will allow names only of letters with first one capital, like Omfgwtf# Default .* (as many of any symbols)CnameTemplate = .*PetNameTemplate = .*

Where exactly to insert and in what form?))
Make an example please)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

change URL = jdbc:mysql://localhost/l2jdb

to URL = jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=utf-8

It needs to be changed only in a config?
Or the database needs to be translated too in UTF8?))

[Evilus]

Try this man

\u0410-\u042f\u0430-\u044f <----Add that where nicks are checked..ie valid names and so on

and in server.properties..

Code: Select all

 ---------------------------------------------------------------------------# Misc Player Settings# ---------------------------------------------------------------------------# Character name template.# Example: CnameTemplate = [A-Z][a-z]{3,3}[A-Za-z0-9]*# The above setting will allow names with first capital letter, next three small letters, and any (capital or not) letter or number, like OmfgWTF1# Most rational to have CnameTemplate = [A-Z][a-z]*# The above setting will allow names only of letters with first one capital, like Omfgwtf# Default .* (as many of any symbols)CnameTemplate = .*PetNameTemplate = .*

Where exactly to insert and in what form?))
Make an example please)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

change URL = jdbc:mysql://localhost/l2jdb

to URL = jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=utf-8

It needs to be changed only in a config?
Or the database needs to be translated too in UTF8?))

CnameTemplate = [A-Za-z0-9\u0410-\u042f\u0430-\u044f]{3,16}
PetNameTemplate = [A-Za-z0-9\u0410-\u042f\u0430-\u044f]{3,16}

and so on

should be enough to only in teh server.properties

[qwerty13]

All work fine. But i have problem with encoding in community board. In region, player name encoding is crazy. O_o