Description:
I have a Table
CREATE TABLE `responseletter` (
`ResponseLetterID` int(10) NOT NULL AUTO_INCREMENT,
`CompanyID` bigint(19) NOT NULL,
`Title` varchar(400) NOT NULL,
`Subject` varchar(400) NOT NULL,
`Salutation` varchar(300) NOT NULL,
<b>`Message` longtext NOT NULL, </b>
`Closing` varchar(300) NOT NULL,
`AddCompanyAddress` tinyint(4) NOT NULL,
`AddContactPerson` tinyint(4) NOT NULL,
`AddEmail` tinyint(4) NOT NULL,
`CreatedByUserID` bigint(19) NOT NULL,
`Createdondatetime` datetime NOT NULL,
`LastModifieddatetime` datetime NOT NULL,
PRIMARY KEY (`ResponseLetterID`),
KEY `FK_ResponseLetter_EmployerContactInfo` (`CompanyID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
In which Message Feild is of Longtext type. When I am Inserted the below content. It is inserting very fine. But When I am updating it
I get a error
Incorrect string value: '\xC2\x93 edi...' for column 'Message' at row 1
I cannot understand what is this. And I did not get solution any where. So please fix this if it is a bug. Or Please dont hesitate to correct me if I am wrong.
Thanks
Ashok Parameswaran.K.
ashok.p@totalebizsolutions.com
Singapore.
How to repeat:
Try to update Message Data Column with the below data.....
"Version 4.2.9 (November 20, 2006): \r\nNew editor to annotate images as well as many other image editing improvements. \r\nCalculated column feature improvements. \r\nNew command line switch for batch building \r\nVersion 4.1.17 (September 28, 2006): \r\nMySQL stability and documentation improvements \r\nNew SQL Server and MySQL database initialization and load tool. \r\nVersion 4.1.4 (August 8, 2006): \r\nForm Letter database field formatting improvements \r\nMemo fields now accept images from an URL or from the file system. \r\nSubstantial print preview improvements. Printing images embedded in HTML memo data is now supported. \r\nQuery Builder improved to now include AppMaker system tables. \r\nVersion 4.1.0 (June 25, 2006): \r\nEmail sending and receiving improvements \r\nEdit screen button manipulation improvements. \r\nMulti-site functionality. \r\nVersion 4.0.42 (June 2, 2006): \r\nOptional Start Up page now supports showing embedded Web Pages. Previously Crystal Reports were shown. To continue to use Crystal in this location you need to convert to a web based report. \r\nScripting Updates \r\nNew Object Operation. FilterLink. \r\nUpdated help for Object Operation Refresh_Link_Replace_Columns \r\nVersion 4.0.41 (May 29, 2006): \r\nTitle background is now a gradient based on the current Windows XP theme. \r\nScripting update: \r\nNew Event, On_ValidateDelete. Add new row (Event, On_ValidateDelete) to table whZSystemMasterConstants. \r\nVersion 4.0.40 (May 25, 2006): \r\nUpdated graphical look. (buttons, scroll bars, etc). \r\nDisplay pictures in grid cells or in html editor fields. \r\nForm letter capabilities \r\nSubstantially reduced download size. \r\nCrystal Reports silent operations. (print direct or export directly). \r\nImproved layout control (lines per data element). \r\nDocument imaging management capabilities. Specifically, multi-page TIFF file creation. Import directly from a scanner. Second and subsequent images automatically converts base image to TIFF and begins a multi page image. \r\nScripting updates: \r\nNew string handling functions (left, right, mid, len, trim, etc.) \r\nNew events. On_Login (return True to disallow login), On_Logout, and a timer event every 5 minutes \r\nRead text files, line by line. \r\nReturn True from On_BeginForm to cancel the edit screen. This is useful when another edit screen is opened via script. \r\nVersion 3.9.15 (July 13, 2005): \r\nEdit screen visual display enhancement showing subtle gradient similar to that used with Windows Explorer. \r\nGreat new sample illustrating advanced searching capabilities (date range, plus others). Included in the Sample1 database application. \r\nApplication icon now self contained and replaceable in the primary application exe file. \r\nDozens of Crystal Report print viewer improvements including one click PDF and RTF exporting. \r\nSeveral command line switches have been provided so edit screens may be invoked from external applications. \r\nMS SQL Server integrated Windows user authentication has been enabled. \r\nThe catalog detail flag \"Visible In Edit\" has been enhanced to allow the field to be hidden, but still remain update-able \r\nNew scripting support for enabling, disabling, hiding, and showing tabs. \r\nNew scripting support for refreshing the display of a sub catalog grid and all associated pick lists. \r\nNew scripting support for returning values from multiple pick list columns. \r\nNew scripting support for database transactions (trx_begin, trx_commit, and trx_rollback). \r\nNew scripting variable {{@Mode}} returns 'A' when in Add Mode and 'C' otherwise.. \r\nNew scripting events for use with field name qualifiers. On_FieldGotFocus, On_FieldChange, On_FieldLostFocus, On_FieldPicked. \r\n\r\nVersion 3.9.2 (April 16, 2005): \r\nImplemented true 128 DES encryption when storing system MS Access database password in the West Heaven License file, dblic.whl. \r\nRe-engineered Branding and Packaging editor. Now only the splash screen, the login box help text, the file list, and the MS Access database password are stored in dblic.whl. The remaining items are now stored in a table in the database. This allows SQL Server and MySQL database applications to be branded simlilar to MS Access database applications. Please note that you will need to delete any dblic.whl files and recreate them using this new version. \r\nCorrections to tool bar item parameters. \r\nEnhanced scripting and Startup pages so that Active-X dlls can be called. In fact, now any externally linked items are called the same whether from the Startup pages, Scripting, or Toolbars. Please be sure to re-test your toolbar buttons and scripts on this new version. \r\nEnhanced Login box. Special help text now displays even after applications are registered. Login box no longer shows as unregistered for applications created by you. Now only the time expiration value (in days) determines evaluation expiration. \r\nScheduling now includes tooltips for overlapping items as well as an iconic indicator (i.e. A Red Exclamation Point). \r\nNew web interface is now availabe in beta format to registered users. The web interface includes a web page main grid, which links to the normal AppMaker edit screen (using Internet Explorer Active-X cab file technology). Watch for new demos in the next few weeks. \r\n\r\nVersion 3.8.1 (March 14, 2005): \r\nSeveral corrections are included that fix problems with encrypting and decrypting the dblic.whl files. Issues occurred when encrypting under one language and then decrypting under another language. As well, other intermittent problems occurred with some passwords. Due to these fixes any existing dblic.whl files need to be re-saved. Designers may notice some extraneous characters in the system and database password fields; and in the key code list. Clearing the characters, or re-entering these values, and re-saving the dblic.whl file will save the file under the new format. \r\nSeveral changes occurred to the AppMaker run time dll files. To use this latest version you must re-install the AppMaker software on all workstations using the software. (this is a normal procedure for new releases; although, the last two version upgrades did not have this restriction). As well, there is a manual procedure required to convert existing 3.7.x databases to the new 3.8.x format. See the West Heaven website for details on manual conversion at http://www.westheaven.com/default.asp?pg=5 \r\nBuilding views is no longer necessary when adding new users. \r\nRe-engineered underlying technology for speedier use, primarily under low bandwidth situations on MS SQL Server and MySQL. \r\nInitial database sizes will be noticably smaller under MS Access. \r\nThe Build All button now sorts all catalogs by type. This allows the building of catalogs to be more efficient, creating pick lists first, then the catalogs that use the pick lists second. Each newly created pick list is internally copied to its parent catalog. This is a result of several optimization techniques that make the software run substantially faster. Note that when changing pick lists, the pick list and the calling catalogs need to be rebuilt. \r\nThe \"reset\" check box has been removed from the building catalogs screen. \r\nF5 now reloads the catalog definitions as well as refreshing the data. This is useful to load changes when developing with one AppMaker session and concurrently running the application with a second AppMaker session. \r\nDragging a column to the top Group By area now automatically hides the grid column. \r\nGroup By columns (that contain replacement values pick lists) no longer need to additionally appear in the grid. \r\nValue to Initially Group By is now an alpha string with up to 8 comma delimited column values. The first 4 values are default groupings and the last 4 values are default sorts. For example, 4,0,0,0,5 will Group By column 4 and then Sort By column 5.
Description: I have a Table CREATE TABLE `responseletter` ( `ResponseLetterID` int(10) NOT NULL AUTO_INCREMENT, `CompanyID` bigint(19) NOT NULL, `Title` varchar(400) NOT NULL, `Subject` varchar(400) NOT NULL, `Salutation` varchar(300) NOT NULL, <b>`Message` longtext NOT NULL, </b> `Closing` varchar(300) NOT NULL, `AddCompanyAddress` tinyint(4) NOT NULL, `AddContactPerson` tinyint(4) NOT NULL, `AddEmail` tinyint(4) NOT NULL, `CreatedByUserID` bigint(19) NOT NULL, `Createdondatetime` datetime NOT NULL, `LastModifieddatetime` datetime NOT NULL, PRIMARY KEY (`ResponseLetterID`), KEY `FK_ResponseLetter_EmployerContactInfo` (`CompanyID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; In which Message Feild is of Longtext type. When I am Inserted the below content. It is inserting very fine. But When I am updating it I get a error Incorrect string value: '\xC2\x93 edi...' for column 'Message' at row 1 I cannot understand what is this. And I did not get solution any where. So please fix this if it is a bug. Or Please dont hesitate to correct me if I am wrong. Thanks Ashok Parameswaran.K. ashok.p@totalebizsolutions.com Singapore. How to repeat: Try to update Message Data Column with the below data..... "Version 4.2.9 (November 20, 2006): \r\nNew editor to annotate images as well as many other image editing improvements. \r\nCalculated column feature improvements. \r\nNew command line switch for batch building \r\nVersion 4.1.17 (September 28, 2006): \r\nMySQL stability and documentation improvements \r\nNew SQL Server and MySQL database initialization and load tool. \r\nVersion 4.1.4 (August 8, 2006): \r\nForm Letter database field formatting improvements \r\nMemo fields now accept images from an URL or from the file system. \r\nSubstantial print preview improvements. Printing images embedded in HTML memo data is now supported. \r\nQuery Builder improved to now include AppMaker system tables. \r\nVersion 4.1.0 (June 25, 2006): \r\nEmail sending and receiving improvements \r\nEdit screen button manipulation improvements. \r\nMulti-site functionality. \r\nVersion 4.0.42 (June 2, 2006): \r\nOptional Start Up page now supports showing embedded Web Pages. Previously Crystal Reports were shown. To continue to use Crystal in this location you need to convert to a web based report. \r\nScripting Updates \r\nNew Object Operation. FilterLink. \r\nUpdated help for Object Operation Refresh_Link_Replace_Columns \r\nVersion 4.0.41 (May 29, 2006): \r\nTitle background is now a gradient based on the current Windows XP theme. \r\nScripting update: \r\nNew Event, On_ValidateDelete. Add new row (Event, On_ValidateDelete) to table whZSystemMasterConstants. \r\nVersion 4.0.40 (May 25, 2006): \r\nUpdated graphical look. (buttons, scroll bars, etc). \r\nDisplay pictures in grid cells or in html editor fields. \r\nForm letter capabilities \r\nSubstantially reduced download size. \r\nCrystal Reports silent operations. (print direct or export directly). \r\nImproved layout control (lines per data element). \r\nDocument imaging management capabilities. Specifically, multi-page TIFF file creation. Import directly from a scanner. Second and subsequent images automatically converts base image to TIFF and begins a multi page image. \r\nScripting updates: \r\nNew string handling functions (left, right, mid, len, trim, etc.) \r\nNew events. On_Login (return True to disallow login), On_Logout, and a timer event every 5 minutes \r\nRead text files, line by line. \r\nReturn True from On_BeginForm to cancel the edit screen. This is useful when another edit screen is opened via script. \r\nVersion 3.9.15 (July 13, 2005): \r\nEdit screen visual display enhancement showing subtle gradient similar to that used with Windows Explorer. \r\nGreat new sample illustrating advanced searching capabilities (date range, plus others). Included in the Sample1 database application. \r\nApplication icon now self contained and replaceable in the primary application exe file. \r\nDozens of Crystal Report print viewer improvements including one click PDF and RTF exporting. \r\nSeveral command line switches have been provided so edit screens may be invoked from external applications. \r\nMS SQL Server integrated Windows user authentication has been enabled. \r\nThe catalog detail flag \"Visible In Edit\" has been enhanced to allow the field to be hidden, but still remain update-able \r\nNew scripting support for enabling, disabling, hiding, and showing tabs. \r\nNew scripting support for refreshing the display of a sub catalog grid and all associated pick lists. \r\nNew scripting support for returning values from multiple pick list columns. \r\nNew scripting support for database transactions (trx_begin, trx_commit, and trx_rollback). \r\nNew scripting variable {{@Mode}} returns 'A' when in Add Mode and 'C' otherwise.. \r\nNew scripting events for use with field name qualifiers. On_FieldGotFocus, On_FieldChange, On_FieldLostFocus, On_FieldPicked. \r\n\r\nVersion 3.9.2 (April 16, 2005): \r\nImplemented true 128 DES encryption when storing system MS Access database password in the West Heaven License file, dblic.whl. \r\nRe-engineered Branding and Packaging editor. Now only the splash screen, the login box help text, the file list, and the MS Access database password are stored in dblic.whl. The remaining items are now stored in a table in the database. This allows SQL Server and MySQL database applications to be branded simlilar to MS Access database applications. Please note that you will need to delete any dblic.whl files and recreate them using this new version. \r\nCorrections to tool bar item parameters. \r\nEnhanced scripting and Startup pages so that Active-X dlls can be called. In fact, now any externally linked items are called the same whether from the Startup pages, Scripting, or Toolbars. Please be sure to re-test your toolbar buttons and scripts on this new version. \r\nEnhanced Login box. Special help text now displays even after applications are registered. Login box no longer shows as unregistered for applications created by you. Now only the time expiration value (in days) determines evaluation expiration. \r\nScheduling now includes tooltips for overlapping items as well as an iconic indicator (i.e. A Red Exclamation Point). \r\nNew web interface is now availabe in beta format to registered users. The web interface includes a web page main grid, which links to the normal AppMaker edit screen (using Internet Explorer Active-X cab file technology). Watch for new demos in the next few weeks. \r\n\r\nVersion 3.8.1 (March 14, 2005): \r\nSeveral corrections are included that fix problems with encrypting and decrypting the dblic.whl files. Issues occurred when encrypting under one language and then decrypting under another language. As well, other intermittent problems occurred with some passwords. Due to these fixes any existing dblic.whl files need to be re-saved. Designers may notice some extraneous characters in the system and database password fields; and in the key code list. Clearing the characters, or re-entering these values, and re-saving the dblic.whl file will save the file under the new format. \r\nSeveral changes occurred to the AppMaker run time dll files. To use this latest version you must re-install the AppMaker software on all workstations using the software. (this is a normal procedure for new releases; although, the last two version upgrades did not have this restriction). As well, there is a manual procedure required to convert existing 3.7.x databases to the new 3.8.x format. See the West Heaven website for details on manual conversion at http://www.westheaven.com/default.asp?pg=5 \r\nBuilding views is no longer necessary when adding new users. \r\nRe-engineered underlying technology for speedier use, primarily under low bandwidth situations on MS SQL Server and MySQL. \r\nInitial database sizes will be noticably smaller under MS Access. \r\nThe Build All button now sorts all catalogs by type. This allows the building of catalogs to be more efficient, creating pick lists first, then the catalogs that use the pick lists second. Each newly created pick list is internally copied to its parent catalog. This is a result of several optimization techniques that make the software run substantially faster. Note that when changing pick lists, the pick list and the calling catalogs need to be rebuilt. \r\nThe \"reset\" check box has been removed from the building catalogs screen. \r\nF5 now reloads the catalog definitions as well as refreshing the data. This is useful to load changes when developing with one AppMaker session and concurrently running the application with a second AppMaker session. \r\nDragging a column to the top Group By area now automatically hides the grid column. \r\nGroup By columns (that contain replacement values pick lists) no longer need to additionally appear in the grid. \r\nValue to Initially Group By is now an alpha string with up to 8 comma delimited column values. The first 4 values are default groupings and the last 4 values are default sorts. For example, 4,0,0,0,5 will Group By column 4 and then Sort By column 5.