Help

12/08/2012 19:49 Murik13#1
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?
12/08/2012 20:10 JohnHeatz#2
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...]
12/08/2012 20:23 Murik13#3
it affects the use of skills?
12/08/2012 20:35 JohnHeatz#4
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
12/08/2012 20:37 nephren#5
If you're from germany make sure you have no ÖÄÜ in it also no ' and special Charakters.
12/08/2012 20:39 Murik13#6
i am not germany but i translate from russian language to english and skills are half english half russian
12/08/2012 20:41 nephren#7
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
12/08/2012 20:46 JohnHeatz#8
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.
12/09/2012 08:44 nubness#9
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.
12/09/2012 08:48 Murik13#10
how? o_o
12/09/2012 09:30 nubness#11
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.
12/09/2012 09:35 Murik13#12
i mean translate desciption/skill name e.t.c
12/09/2012 10:03 nubness#13
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.
12/09/2012 12:41 DenyA#14
Quote:
Originally Posted by nubness View Post
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.
12/09/2012 12:44 nubness#15
Such a thing already exists. It was released by bulgaria.