Japanese in MySQL

[Keitaro]

Hi,

I am developing a vocabulary trainer.
The languages I want to support are German and Japanese.
When I try to store Japanese characters in my mysql database, I do not
get the correct characters. The entry of the field is "???" instead of
the Japanese character. I tried to store the character with my java
application and with the MySQL Control Center. I know I have to
configure the mysql database. But I do not know how. I created my
database with the following sql statements:

CREATE TABLE vocab
(
Japanese VARCHAR(100) CHARACTER SET utf8,
German VARCHAR(100) CHARACTER SET utf8
);

But this did not work.
I hope you can help me, because I have a lot of Japanese words to
learn ;-)

Ciao
Keitaro

[OneSolution]

How can you store Japanese as UTF 8? Japanese is a two bit character set,
so each Japanese character will take 2 bits, as opposed to Latin, which
takes one bit. So you'd have to explicitly set that field to accomodate
that by choosing the right character set.
"Keitaro" <ke*******@yahoo.de> wrote in message
news:3e**************************@posting.google.c om...

Hi,

I am developing a vocabulary trainer.
The languages I want to support are German and Japanese.
When I try to store Japanese characters in my mysql database, I do not
get the correct characters. The entry of the field is "???" instead of
the Japanese character. I tried to store the character with my java
application and with the MySQL Control Center. I know I have to
configure the mysql database. But I do not know how. I created my
database with the following sql statements:

CREATE TABLE vocab
(
Japanese VARCHAR(100) CHARACTER SET utf8,
German VARCHAR(100) CHARACTER SET utf8
);

But this did not work.
I hope you can help me, because I have a lot of Japanese words to
learn ;-)

Ciao
Keitaro

[OneSolution]

How can you store Japanese as UTF 8? Japanese is a two bit character set,
so each Japanese character will take 2 bits, as opposed to Latin, which
takes one bit. So you'd have to explicitly set that field to accomodate
that by choosing the right character set.
"Keitaro" <ke*******@yahoo.de> wrote in message
news:3e**************************@posting.google.c om...

Hi,

I am developing a vocabulary trainer.
The languages I want to support are German and Japanese.
When I try to store Japanese characters in my mysql database, I do not
get the correct characters. The entry of the field is "???" instead of
the Japanese character. I tried to store the character with my java
application and with the MySQL Control Center. I know I have to
configure the mysql database. But I do not know how. I created my
database with the following sql statements:

CREATE TABLE vocab
(
Japanese VARCHAR(100) CHARACTER SET utf8,
German VARCHAR(100) CHARACTER SET utf8
);

But this did not work.
I hope you can help me, because I have a lot of Japanese words to
learn ;-)

Ciao
Keitaro

[OneSolution]

How can you store Japanese as UTF 8? Japanese is a two bit character set,
so each Japanese character will take 2 bits, as opposed to Latin, which
takes one bit. So you'd have to explicitly set that field to accomodate
that by choosing the right character set.
"Keitaro" <ke*******@yahoo.de> wrote in message
news:3e**************************@posting.google.c om...

Hi,

I am developing a vocabulary trainer.
The languages I want to support are German and Japanese.
When I try to store Japanese characters in my mysql database, I do not
get the correct characters. The entry of the field is "???" instead of
the Japanese character. I tried to store the character with my java
application and with the MySQL Control Center. I know I have to
configure the mysql database. But I do not know how. I created my
database with the following sql statements:

CREATE TABLE vocab
(
Japanese VARCHAR(100) CHARACTER SET utf8,
German VARCHAR(100) CHARACTER SET utf8
);

But this did not work.
I hope you can help me, because I have a lot of Japanese words to
learn ;-)

Ciao
Keitaro