Truncate string when insert

Hi all

I have dump insert statement in mysql, It is very strange that some other mysql engine did not insert full string:
e.g;
insert into mytable (page, modul_id, layout, designable, type, config, name)
('bb/eintrag/default',23,'table',1,'default',0,'#request.text(\"dbtext Einträge von A bis Z\")#')

So the name value must be #request.text(\"dbtext Einträge von A bis Z\")# but it inserted #request.text("dbtext Eintr
The field "name" is varchar(255)

Any idea?
LVL 17
HuyBDAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
insert into mytable (page, modul_id, layout, designable, type, config, name)
('bb/eintrag/default',23,'table',1,'default',0,'#request.text(\\"dbtext Einträge von A bis Z\\")#')
0
 
HuyBDAuthor Commented:
Thank AngelIII.
I have missing, the actual data is #request.text("dbtext Einträge von A bis Z")#
the backward slash was added when I export data, and the value of field after I insert to another db is #request.text("dbtext Eintr
the value that exec your query is #request.text(\"dbtext Eintr
I dont known what option to set, some machine work well while another is not, I use SQLyog 4.1
I will run query with other tool and inform you result later

0
 
HuyBDAuthor Commented:
Yes, It cause by SQLyog,
thanks anyway!
0
All Courses

From novice to tech pro — start learning today.