Hello.
I have problem in showing sql results in Squirrel eighter on java code.
(connection string is : jdbc:mysql://localhost/mydb )

select 'àáâ'
(can you see Hebrew ?).

I see that the result in Squrrel eighter on java code is ??? (three question remarks).

How can I solve the above ?

Thanks

On Wed, 16 Apr 2008 14:25:12 +0200, Mr. X.
<no_spam_please@nospam_please.com> wrote:

> Hello.
> I have problem in showing sql results in Squirrel eighter on java code.
> (connection string is : jdbc:mysql://localhost/mydb )
>
> select '�בג'
> (can you see Hebrew ?).
>
> I see that the result in Squrrel eighter on java code is ??? (three
> question remarks).
>
> How can I solve the above ?

The question is where it goes wrong. It might be with MySQL, but also
further on in your application itself. Usually a SET NAMES here is enough,
see <http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html>.
--
Rik Wasmus

O.K.
I will check it out.
Besides, it is not only that java code has problem with that, but also tools
like Squirrel.

I don't know how to link the correct charset, and what ini file is for
mysql.
There are several ini file - How can I know which is the default one ?
Is there any configuration utilility for mysql ?

Thanks