Hello,
I configured MySQL database in Fedora Linux. In 'test' database I
created 'books' table, setting Character Set = UTF-8 Unicode and Collation
= utf8_general_ci. When I enetered into varchar column 'title' Polish
text "Hodowla żółwi" I received: Incorrect string
value: "\xC5\xBC\xC3\xB3\xC5\x82..." for column 'title' at row 1. When I use
query 'SELECT title FROM books' I see "Hodowla ?ó?wi" instead of "Hodowla
żółwi".
So I have a question: How can I use utf-8 non-latin characters?
/RAM/

On Tue, 04 Mar 2008 11:57:30 +0100, R.A.M. wrote:
> Hello,
> I configured MySQL database in Fedora Linux. In 'test' database I
> created 'books' table, setting Character Set = UTF-8 Unicode and Collation
>= utf8_general_ci. When I enetered into varchar column 'title' Polish
> text "Hodowla ?ó?wi" I received: Incorrect string
> value: "\xC5\xBC\xC3\xB3\xC5\x82..." for column 'title' at row 1. When I use
> query 'SELECT title FROM books' I see "Hodowla ?ó?wi" instead of "Hodowla
> ?ó?wi".
> So I have a question: How can I use utf-8 non-latin characters?
> /RAM/

Those hex bytes you've transcribed come out z with a dot, o with an acute
accent, l with a diagonal crossbar. Since the bit I see after "Hodowla"
in yout post also look identical on my terminal (which is not a UTF-8
terminal), then I think MySQL is working just fine and either the tool
you're using to access MySQL or your terminal (like mine) is not as
UTF-8 aware as one might hope. Set up the terminal correctly, and you'll
be happy.

--
If sharing a thing in no way diminishes it, it is not rightly owned if it is
not shared. -- St. Augustine

OK, problem solved.
I had to set utf-8 individually for each column (instead of setting utf-8
for the 'books' table).
/RAM/