Mysql Sqlstate Hy000 Error Code 1366

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about

Mysql Error 1366 Incorrect String Value

hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges incorrect string value mysql Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each

Sqlstate Hy000 Error 2002

other. Join them; it only takes a minute: Sign up How to handle SQL state [HY000]; error code [1366]; Incorrect string value? up vote 4 down vote favorite 3 I'm aware this error means a mysql column doesn't accept sql state hy000 error code 0 the value, but this is strange, since the value fits in a Java UTF-8 encoded string, and the mysql column is utf8_general_ci. Also, all utf8 characters have worked properly so far, apart from these. The use-case is: I am importing tweets. The tweet in question is: https://twitter.com/bakervin/status/210054214951518212 - you can see the two "strange" characters (and two strange whitespaces between them). The question is - how to handle this: trim these characters (how - which are they, how general error 1366 incorrect string value does the Java UTF-8 differ from MySQL one) make the column capable of accepting this value (how - is there anything more utf-y than utf8_general_ci) java mysql utf-8 share|improve this question asked Jun 15 '12 at 20:02 Bozho 385k82773946 add a comment| 1 Answer 1 active oldest votes up vote 7 down vote accepted These appear to be unicode surrogate characters. Since they are not actual characters, and it seems MySQL doesn't support them, it is safe to trim them: StringBuilder sb = new StringBuilder(); for (int i = 0; i < text.length(); i++) { char ch = text.charAt(i); if (!Character.isHighSurrogate(ch) && !Character.isLowSurrogate(ch)) { sb.append(ch); } } return sb.toString(); share|improve this answer answered Jun 16 '12 at 5:59 Bozho 385k82773946 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged java mysql utf-8 or ask your own question. asked 4 years ago viewed 6420 times active 4 years ago Related 3Parse from XML, insert to mysql; characters give java.sql.SQLException: Incorrect string value01366 mysql incorrect string value for Zhuyin Fuhao8Mysql2::Error: Incorrect string value for Turkish characters14Incorr

Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices

Error 1366 (hy000) Incorrect String Value

General Information Installing and Upgrading MySQL Tutorial MySQL Programs MySQL sqlstate hy000 general error Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators

Mysql Incorrect String Value For Column At Row 1

SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.2 Partitioning Stored Programs and Views INFORMATION_SCHEMA http://stackoverflow.com/questions/11057463/how-to-handle-sql-state-hy000-error-code-1366-incorrect-string-value Tables MySQL Performance Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.5 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to https://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL V

Replica Log Enforcing Workspace Configurations Hint: Search defaults to *AND*; use *OR* between words to get alternate results. Reset http://answers.perforce.com/articles/KB/2724 Search Search < Back to search results MySQL error: Incorrect string value: 'xF2xB6xA9xB8' for column 'DESC'Printable View «Go BackInformation Problem While replicating, P4toDB https://suhasjavablog.wordpress.com/2012/08/26/how-to-handle-sql-state-hy000-error-code-1366-in-mysql/ displays an "Incorrect string value" exception. Example: May 7, 2011 5:14:26 PM com.perforce.p4todb.Messages log SEVERE: SQL exception: pos: 2281#218144055978 0 false false, prev_pos: 2281#218136953030 10081 incorrect string false false Incorrect string value: '\xF2\xB6\xA9\xB8\xEF\xBF...' for column 'DESC' at row 1 SQL state: HY000 Vendor error code: 1,366 Fetched from position: 2281#218136953030 10081 false false Lines: 2,294 java.sql.BatchUpdateException: Incorrect string value: '\xF2\xB6\xA9\xB8\xEF\xBF...' for column 'DESC' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2024) at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449) at com.perforce.p4todb.p4todb.execute_statements(p4todb.java:2942) Note:  the actual string value incorrect string value and column name may be different. SolutionExamine the string value to determine the problem character. Use the UTF-8 Codepage layout on http://en.wikipedia.org/wiki/UTF-8#Codepage_layout to determine the number of bytes based on the first byte in the string value given. For the above example, the first byte is \xF2 and in UTF-8 this means it is the start of a character encoded with four bytes.If the character is four bytes, you must alter the table definitions and  configure the MySQL server to accept four byte UTF-8 characters.   When finished, restart P4toDB; it will continue from where it failed.If the character is a five or six byte encoding, MySQL does not support it.  Contact Perforce Support for assistance in working around this situation. Configuring P4toDB tables to Support Four Byte UTF-8 Encodings If the column name in the exception is DESC, start your favorite SQL query tool and run these

What you might've Missed November 2015(3) June 2015(1) July 2014(1) May 2014(1) April 2014(5) February 2014(1) January 2014(1) October 2013(1) September 2013(4) June 2013(1) March 2013(3) August 2012(1) April 2012(1) March 2012(1) January 2012(1) December 2011(4) November 2011(13) October 2011(15) September 2011(1) August 2011(13) July 2011(1) June 2011(8) December 2010(4) September 2010(2) July 2010(1) June 2010(1) April 2010(1) March 2010(9) February 2010(4) December 2009(9) November 2009(3) August 2009(1) June 2009(16) ShamanOfJava's Twitter updates RT @MesutOzil1088: I hope to see more of those dance moves @Arsenal soon... 👊💃😅 @MustafiOfficial @mertesacker #GermanGunners https://t.co/… 1monthago How to resolve liquibase lock error? suhasjavablog.wordpress.com/?p=666 2monthsago How to set active tab in primefaces tab view ? suhasjavablog.wordpress.com/2015/11/23/how… 11monthsago How to handle SQL state [HY000] , error code [1366] in MySQL? Posted: August 26, 2012 in Database Tags: message length, unicode characters 0 This is one of the common problems that might arise if you are using MySQL Database for your project. Often our project encoding is UTF-8 but many are not aware of the fact that MySQL supports utf8-support_ci format for the database columns. In such cases, while we are trying to persist the application data into the MySQL database, we will encounter the following error.   SQL state [HY000]; error code [1366] This is due to Unicode Surrogates. (You can read more about them here http://en.wikipedia.org/wiki/Mapping_of_Unicode_characters#Surrogates ) Surrogate characters are not real characters. They are reserved for UTF-16 encoding. So the fix for this problem is to trim these character using the method   boolean java.lang.Character.isHighSurrogate(char ch)   and   boolean java.lang.Character.isLowSurrogate(char ch) Example : public static String trimUnicodeSurrogateCharacters(String message) {     StringBuilder sb = new StringBuilder();    for (int i = 0; i < message.length(); i++) {          char ch = text.charAt(i);          if (!Character.isHighSurrogate(ch) && !Character.isLowSurrogate(ch)) {              sb.append(ch);       }   }  return sb.toString(); } Like this:Like Loading... Related Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account.