Why do I create a character showing a question mark? Please help me. Can you help me

[mobai520]

Why do I create a character showing a question mark? Please help me. Can you help me to display Chinese in China? Database please help me modify it to support any country's display

[Dr. Peacock]

For what is the Download Link ? xD

Do you mean/want Multi-Language ?

[mobai520]

Originally Posted by Dr. Peacock

For what is the Download Link ? xD

Do you mean/want Multi-Language ?

Yes, this database does not support the languages of any country except English

[Dr. Peacock]

Originally Posted by mobai520

Yes, this database does not support the languages of any country except English

For what you need the Database ? o:
Multi-Language = Resource / Source....
Database = SAVE PLAYER: Position,Items, etc.
You want to save the Selected Language ? -> Neuz.ini ?

[_Suffer]

I guess he means that if he types something in chinese a "?" appears because the game dont support chinese letters
correct me if im wrong

[mobai520]

Originally Posted by _Suffer

I guess he means that if he types something in chinese a "?" appears because the game dont support chinese letters
correct me if im wrong

Yes, I am in China. The Chinese language database does not support Chinese language in China. There are question marks in the creation of Chinese and Chinese. English can be displayed normally.

Originally Posted by Dr. Peacock

For what you need the Database ? o:
Multi-Language = Resource / Source....
Database = SAVE PLAYER: Position,Items, etc.
You want to save the Selected Language ? -> Neuz.ini ?

Yes, I need a database to support any country's language, I use Chinese in Chinese, but when I create a character to enter the game, there is a question mark. Can you help me?

[xTwiLightx]

Use NVARCHAR as data type for fields and variables that contain names like

CHARACTER_TBL.dbo.m_szName

or

GUILD_TBL.dbo.m_szGuild

and use the "N" prefix for string literals in insertion/updates inside stored procedures or direct queries as well:

update .... set someColumn = N'测试'

[mobai520]

Originally Posted by xTwiLightx

Use NVARCHAR as data type for fields and variables that contain names like

CHARACTER_TBL.dbo.m_szName

or

GUILD_TBL.dbo.m_szGuild

and use the "N" prefix for string literals in insertion/updates inside stored procedures or direct queries as well:

update .... set someColumn = N'测试'

I can't find it and modify it. Please help me. . Thank you

[xTwiLightx]

Originally Posted by mobai520

I can't find it and modify it. Please help me. . Thank you

I already did.

You will need to re-create the tables or do some migration work in order to achieve the change of data.

create table [dbo].[tableName]
  szName nvarchar(32),
  ... ...

alter proc [dbo].[procedureName]
  @sz_Name nvarchar(32),
  ... ...
as

I guess you should get what you need to change.

[mobai520]

Originally Posted by xTwiLightx

I already did.

You will need to re-create the tables or do some migration work in order to achieve the change of data.

create table [dbo].[tableName]
  szName nvarchar(32),
  ... ...

alter proc [dbo].[procedureName]
  @sz_Name nvarchar(32),
  ... ...
as

I guess you should get what you need to change.

Sorry, I just tried to execute the code, shows an error, I am a newcomer does not understand this database, the above connection is my upload database is also downloaded from this forum, you can help me modify it to upload to me, thank you you

[xTwiLightx]

Originally Posted by mobai520

Sorry, I just tried to execute the code, shows an error, I am a newcomer does not understand this database, the above connection is my upload database is also downloaded from this forum, you can help me modify it to upload to me, thank you you

This was just some example code to show what is needed to be changed.

Better take a clean database by using the creation scripts and change "varchar" to "nvarchar" when appropriate (which should be character and guild names only, I guess).

[mobai520]

Originally Posted by xTwiLightx

This was just some example code to show what is needed to be changed.

Better take a clean database by using the creation scripts and change "varchar" to "nvarchar" when appropriate (which should be character and guild names only, I guess).

Well, thanks for your help, I'll try it.

[mobai520]

Originally Posted by Dr. Peacock

For what is the Download Link ? xD

Do you mean/want Multi-Language ?

Yes, such as Chinese Mandarin