Page 1 of 1
Russian NickName
Posted: Fri Jun 12, 2009 3:08 pm
by 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.
Re: Russian NickName
Posted: Fri Jun 12, 2009 3:58 pm
by qwerty13
Try to set utf-8 encoding for your database.
and look this lines in config
CnameTemplate = .*
PetNameTemplate = .*
Re: Russian NickName
Posted: Fri Jun 12, 2009 4:08 pm
by managerlexx
In which table to put coding UTF8?
And in what column?
Or it is necessary to put coding UTF8 to all database?
Re: Russian NickName
Posted: Fri Jun 12, 2009 4:56 pm
by 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.
Re: Russian NickName
Posted: Fri Jun 12, 2009 7:04 pm
by qwerty13
Or use russian offical client.
Re: Russian NickName
Posted: Sun Jun 14, 2009 3:13 pm
by managerlexx
Matter is not in the game client:)
At input NickName in Russian in a database it is saved in sort- ??????? - Here such characters.
Re: Russian NickName
Posted: Fri Jun 19, 2009 2:22 am
by 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
Re: Russian NickName
Posted: Fri Jun 19, 2009 2:24 am
by _DS_
Works for me by just using utf8 for database (and proper client).
Re: Russian NickName
Posted: Fri Jun 19, 2009 5:55 am
by 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), ...
Re: Russian NickName
Posted: Fri Jun 19, 2009 2:59 pm
by managerlexx
Evilus wrote: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)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Evilus wrote:
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?))
Re: Russian NickName
Posted: Fri Jun 19, 2009 3:51 pm
by Evilus
managerlexx wrote:Evilus wrote: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)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Evilus wrote:
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
Re: Russian NickName
Posted: Fri Jun 19, 2009 7:04 pm
by qwerty13
All work fine. But i have problem with encoding in community board. In region, player name encoding is crazy. O_o