Help

[Murik13]

I translated some skills and when i execute skill.sql it gives me error

Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.


Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 2
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 3
String or binary data would be truncated.
The statement has been terminated.


some 1 can tell me why?

[JohnHeatz]

Basically, you are entering a string longer than what it is set up to be.

You might want to refer to this article

[Murik13]

it affects the use of skills?

[JohnHeatz]

Your query is not being executed, not sure what you are doing there, so I don't know if it would or would not affect it

[nephren]

If you're from germany make sure you have no ÖÄÜ in it also no ' and special Charakters.

[Murik13]

i am not germany but i translate from russian language to english and skills are half english half russian

[nephren]

String or Binary data are some ASCII Characters, Special Characters and ÖÄÜ.
Let them out if you use it.

If not, all i can say is the same as John: i'm not sure what are you doing

[JohnHeatz]

What happens in here, if I got you right, is that what you are translating, for example, is meant to be a varchar(20) and during the translation you are putting a 22 characters long string, therefore this issue will be caused.

[nubness]

What if I told you that you can run a query generated by ShStudio from the english Skill.SData ? It gets the job done in less than 1 minute.

[Murik13]

how? o_o

[nubness]

Open Shaiya Studio -> Tools -> Settings and set a location to save server data.
Open an english Skill.SData in Shaiya Studio, do a small change then undo it so Shaiya Studio understands that you did something there, save it and check the folder where Shaiya Studio saves the server data, you'll find a file named Skill.sql there. Run that query. It will complete with errors, but those aren't affecting you at all.

[Murik13]

i mean translate desciption/skill name e.t.c

[nubness]

Let me make this clear enough for you. What players see in game is in the client ONLY. What actually is/happens is server sided. If you want to change the skill names and description you need to do it in Skill.SData.

[DenyA]

Originally Posted by nubness

Let me make this clear enough for you. What players see in game is in the client ONLY. What actually is/happens is server sided. If you want to change the skill names and description you need to do it in Skill.SData.

He Translated skills ep 6 russian to english. He want realeased ep 6 skill data on english language.

[nubness]

Such a thing already exists. It was released by bulgaria.