0

I am running a .sql file against my database to build the tables. However Once i reach the Create tbl_static i recieve the following error on one of the insert statements:

MySQL said: Documentation
#1366 - Incorrect string value: '\x80\x99s Ba...' for column 'fld_description' at row 1

The Insert Statement at row 1 is as follows:

INSERT INTO `tbl_static` VALUES(1, '\r\n<html><head></head><body><table><tbody><tr><td align="left"><span class="main-text"><strong>Main Office Address:</strong><br />2800 W. March Lane, <br />Suite 340, Stockton, <br />Ca 95219. 209-957-3989.</span></td></tr></tbody></table><p /><p /><p /></body></html>', 'Contact-Us', NULL);

And the table is defined as follows:

CREATE TABLE `tbl_static` (
  `id` int(10) NOT NULL auto_increment,
  `fld_description` text NOT NULL,
  `fld_title` varchar(50) NOT NULL default '',
  `image` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

Where is the error???????

3
Contributors
5
Replies
9
Views
9 Years
Discussion Span
Last Post by trudge
0

What is causing the issue then? I have copied the data to a new file, and recieved the same issue.

0

There might be some issue with file encoding. Because these queries can be executed without any problem if run on command prompt/GUI.

So the only thing that can create problem is file.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.