error code [1366]; Incorrect string value: '\xF4\x80\x80\xB9Bu...'
Posted by: Bambarbia Kirkudu
Date: May 22, 2007 08:04PM

I have very strange exceptions, using JDBC-client, UTF-8 for both parties, and LONGTEXT field:

2007-05-22 21:53:16,849 [eshop.macsales.com ] ERROR org.tokenizer.fetcher.FetcherThread - http://eshop.macsales.com/OSXCenter/XPostFacto/Archive/XPostFacto3.1a3.sitx
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [update web_resource set url_actual=?, last_success_time=?, fail_num=?, status_code=?, status_text=?, text=?, html=? where resource_id=?]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF2\x9F\xB0\x98}\x0E...' for column 'text' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF2\x9F\xB0\x98}\x0E...' for column 'text' at row 1
Caused by:
java.sql.SQLException: Incorrect string value: '\xF2\x9F\xB0\x98}\x0E...' for column 'text' at row 1


What does that mean: "nested exception is java.sql.SQLException: Incorrect string value: '\xF2\x9F\xB0\x98}\x0E...' for column 'text' at row 1"???

Is it JDBC driver? why such string? Note please that "Nested exception ..." means exact reply from Server. Why Server uses such encodings? '\xF2\x9F\xB0\x98}\x0E...'

I expected that Server uses UTF-8 even for exceptions!



Edited 1 time(s). Last edit at 05/23/2007 11:34AM by Bambarbia Kirkudu.

Options: ReplyQuote


Subject
Views
Written By
Posted
error code [1366]; Incorrect string value: '\xF4\x80\x80\xB9Bu...'
105960
May 22, 2007 08:04PM
42876
May 23, 2007 11:45AM
21085
November 30, 2007 03:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.