Hi all,
there is no conversion done, and mysql will stil be happy to export utf8
(if asked to do so with a set names). So what is the role of the
character set and collation at the database level?From what I understand
the collation is used when you want to order results for example, case
For information for other people who would have the same problem:
Warning
Do not issue the query 'set names' with Connector/J, as the driver will not
detect that the character set has changed, and will continue to use the
character set detected during the initial connection setup.
To allow
for your help,
melanie
If you write an hungarian article about your test, maybe you will plan an
english translation?or is hungarian hard to learn? :-)
From: BÁRTHÁZI András [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: character sets.(missing
Hi Melanie,
Thanks for the explanation, I will try the SET NAMES to export my XML
file in utf8 (I actually want it to be in utf8)
I'm sorry if this is a basic question, but as I said before I'm kind of
lost with the encodings
I asked almost the same here about a week ago, so I don't
sorry i should have put the result of the show variables:
*** 5. row ***
Variable_name: character_set_client
Value: latin1
*** 6. row ***
Variable_name: character_set_connection
Value:
Hi,
if the character_set_client is by default latin1, does that mean that
the java application is sending latin1?or is it changed at runtime?
kind of lost again.
As I understand, the charset of the column/table/database is irrelevant,
there will be no conversion if you query from or