MySql with Hebrew.

Thread view:

Mr. X. - 04 Apr 2008 11:03 GMT

Hello.
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.

Thanks :)

Reply to this Message

RedGrittyBrick - 04 Apr 2008 11:37 GMT

> Hello.
> 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.

Have you read this:
http://dev.mysql.com/tech-resources/articles/4.1/unicode.html

Please use a MySQL forum for MySQL questions.

IIRC SQuirreL is written in Java.
http://mindprod.com/jgloss/unicode.html

Signature

RGB

Reply to this Message

Roedy Green - 04 Apr 2008 21:50 GMT

On Fri, 4 Apr 2008 13:03:56 +0300, "Mr. X."
<no_spam_please@nospam_please.com> 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.

Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Reply to this Message

Mr. X. - 14 Apr 2008 04:19 GMT

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 :)

Reply to this Message

Mr. X. - 14 Apr 2008 04:24 GMT

About select 'אבג' :
just put three letters on Hebrew...

Reply to this Message

Mr. X. - 14 Apr 2008 04:49 GMT

...
I don't know what extactly to change
(I have changed my.ini : default-character-set=UTF-8,
and restart the service of mysql,
but it didn't help,
and I don't know exactly if I did changes on the right place, since there are several ini file by default, and I don't know how which service is connected to which file ?)

Thanks :)

Reply to this Message

RedGrittyBrick - 14 Apr 2008 12:00 GMT

> Hello.
> Also in Squirrel eighter on java code
[quoted text clipped - 4 lines]
>
> 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.

Signature

RGB

Reply to this Message

Mr. X. - 24 Apr 2008 21:22 GMT

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 :)

Reply to this Message

Mr. X. - 24 Apr 2008 21:33 GMT

...
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 :)

Reply to this Message

Lew - 25 Apr 2008 00:37 GMT

> ...
> O.K.
[quoted text clipped - 7 lines]
>
> 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>

Signature

Lew

Reply to this Message

Mr. X. - 25 Apr 2008 21:40 GMT

What's wrong of the following :

alter database cashereg character set utf8 (first statement)
select 'א' (second statement)

(The select statement doesn't show on the results the Hebrew characters).

Thanks :)

Reply to this Message

Mr. X. - 25 Apr 2008 21:57 GMT

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.

Thanks :)

Reply to this Message

Lew - 26 Apr 2008 00:41 GMT

> I think I am getting in progress :
> When I ran :
[quoted text clipped - 6 lines]
> 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.

Signature

Lew

Reply to this Message

MySql with Hebrew.

Free Magazines