Help

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?

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

You might want to refer to this article

[Only registered and activated users can see links. Click Here To Register...]

it affects the use of skills?

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

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

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

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

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.

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.

how? o_o

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.

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

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.

Quote:

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.

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