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