By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,333 Members | 1,843 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,333 IT Pros & Developers. It's quick & easy.

Japanese in MySQL

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
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

Jul 19 '05 #3

P: n/a
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

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.