Solved

Truncate string when insert

Posted on 2006-06-26
3
2,225 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
  • 2
3 Comments
 
LVL 142

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

706 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now