Solved

Truncate string when insert

Posted on 2006-06-26
3
2,242 Views
Last Modified: 2011-09-20
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?
0
Comment
Question by:HuyBD
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 16982308
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
 
LVL 17

Author Comment

by:HuyBD
ID: 16982491
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
 
LVL 17

Author Comment

by:HuyBD
ID: 16990641
Yes, It cause by SQLyog,
thanks anyway!
0

Featured Post

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question