MySQL Bugs: #5517: Backtick in field will show as empty field

Bug #5517	Backtick in field will show as empty field
Submitted:	10 Sep 2004 15:12	Modified:	3 Nov 2004 12:55
Reporter:	Holger Kunst	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	1.0.7 beta	OS:	Windows (Win XP, SP2)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If a field value contains a backtick the field will display empty in Query Browser.

How to repeat:
The first row will show and empty "info" field - the second one will show correctly.

DROP TABLE IF EXISTS test;
CREATE TABLE test (
  contact_id int(11) NOT NULL auto_increment,
  info text,
  PRIMARY KEY  (contact_id)
) TYPE=MyISAM;

INSERT INTO test VALUES (200,'This field contains a backtick ’');
INSERT INTO test VALUES (201,'This one does not');

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/