MySql with Hebrew.

On Fri, 4 Apr 2008 13:03:56 +0300, "Mr. X."
wrote, quoted or indirectly quoted
someone who said :

>I want to use MySql with Hebrew.
>I am using also Squirrel as a navigator.
>How can I use in mysql either Squirrel with Hebrew.

Often you can configure a database with which encoding it should store
the database. I think JDBC always uses Unicode. So if you are
writing in Java, I would think you don't need to do anything special
to fetch your data, just to display it, right to left, and to make
your layouts align the mirror of the usual.

see http://mindprod.com/jgloss/hebrew.html
for some tips on using Hebrew in Java.
--

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com
 >> Stay informed about: MySql with Hebrew. 

Hello.
Also in Squirrel eighter on java code
(connection string is : jdbc:mysql://localhost/mydb )

select '???'
(can you see Hebrew ?).

I see that the result is ??? (three question remarks).

How can I solve the above ?

Thanks
 >> Stay informed about: MySql with Hebrew. 

Mr. X. wrote:
> Hello.
> Also in Squirrel eighter on java code
> (connection string is : jdbc:mysql://localhost/mydb )
>
> select '???'
> (can you see Hebrew ?).
>
> I see that the result is ??? (three question remarks).

It works fine for me using SQuirreL 2.2 and Derby
select code, 'foo', 'אבג', 'bar' from app.customer;
returned a nice table with Hebrew characters in the 3rd column.

>
> How can I solve the above ?
>

I think it's not a Java programming problem.
Try asking in comp.databases.mysql

Try using MySQL's command line tools
http://dev.mysql.com/doc/refman/5.1/en/mysql.html
Obviously, you'll have to set up your command line environment to use a
character set/encoding/font that supports Hebrew.


If you can get MySQL's command line tools to behave the way you want, I
expect getting SQuirreL and Java to do what you want should be easier.

--
RGB
 >> Stay informed about: MySql with Hebrew. 

Thanks ...

1. My question is for mysql & not derby.
2. I have tried the newsgroup comp.database.mysql - no one realy answer.
3. I will check the link you gave again, but since I watched that link, I
think I could not grasp what to do to solve Hebrew-problems as I've
mentioned.

Thanks
 >> Stay informed about: MySql with Hebrew. 

....
O.K.
There is command :
show create database mydb.
results are (columns seperated by ",")
mydb, CREATE DATABASE `cashereg` /*!40100 DEFAULT CHARACTER SET latin1 */

....
Well it is not utf-8 character-set.

How can I change the above setting ?

Thanks
 >> Stay informed about: MySql with Hebrew. 

Mr. X. wrote:
> ...
> O.K.
> There is command :
> show create database mydb.
> results are (columns seperated by ",")
> mydb, CREATE DATABASE `cashereg` /*!40100 DEFAULT CHARACTER SET latin1 */
>
> ...
> Well it is not utf-8 character-set.
>
> How can I change the above setting ?

Have you considered reading the documentation?
<http://dev.mysql.com/doc/refman/5.1/en/alter-database.html>

--
Lew
 >> Stay informed about: MySql with Hebrew. 

Mr. X. wrote:
> I think I am getting in progress :
> When I ran :
> *shell> mysqld-nt --character-set-server=hebrew*
> and not running mysqld as a windows' service (besides, how can I run a
> service with parameters ?)
>
> ... the select 'א' returns 'א' (I now see the hebrew).
>
> and also - what is the default ini-file, when I run the service with no
> parameters.

This is a Java newsgroup. While it's possible someone here might have an
answer, you'd be better off finding a group devoted to MySQL issues.

--
Lew
 >> Stay informed about: MySql with Hebrew.