Query using unicode

[Kris]

Hi,

I have set up a MySQL database (MySQL 4.1) which is encoded in UTF-8
with the utf8_general_ci collation. Inserted into the database is some
Japanese dictionary information.

Now I'd like to querie my database from within a PHP5 script. I have a
webform where the user inputs the Japanese data that needs to be queried
(webpage uses UTF-8 encoding). In my script I tell the database that I'm
sending unicode data: $db->query("SET NAMES 'utf8'");

Then I construct a query that looks like:

SELECT * FROM EDICT WHERE KANA=$term

The variable term contains the user inputted utf-8 data. However, this
query does not work. It gives zero results (and I've made sure that the
requested data is actually in the database).

The data in $term seems correct (it displays correctly when I echo the
variable).

What am I missing here?

[badz]

i still new also in the field but just want to throw an idea.. is we
need to do some header control ...
to indicate that our form is japanese charachter form set ??

any one can help??

[Kris]

badz wrote:

i still new also in the field but just want to throw an idea.. is we
need to do some header control ...
to indicate that our form is japanese charachter form set ??

any one can help??

Actually the form is working ok (I have the following header in my html:

<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />

You can check it at www.belgium-anime.com/vocablist/search.php5

Try for example to look for the word $B$O$J$S(B (hanabi) (this message is
encoded in ISO-2022-JP). This word is in my vocabulary list. I can
retrieve the input from the form correctly (As you can see when
submitting the form. The inputted data gets displayed correctly, the
query is also displayed correctly).

For some reason the query gives no result. I'm sure the data in my
database is correct, because I use it for another webpage
(www.belgium-anime.com./vocablist/index.php5).

Do I perhaps need a special comparison operator to compare non-standard
text?

Any help is appreciated!

[Jan Pieter Kunst]

Kris wrote:

badz wrote:

i still new also in the field but just want to throw an idea.. is we
need to do some header control ...
to indicate that our form is japanese charachter form set ??

any one can help??

Actually the form is working ok (I have the following header in my html:

<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />

You can check it at www.belgium-anime.com/vocablist/search.php5

Try for example to look for the word $B$O$J$S(B (hanabi) (this message is
encoded in ISO-2022-JP). This word is in my vocabulary list. I can
retrieve the input from the form correctly (As you can see when
submitting the form. The inputted data gets displayed correctly, the
query is also displayed correctly).

For some reason the query gives no result. I'm sure the data in my
database is correct, because I use it for another webpage
(www.belgium-anime.com./vocablist/index.php5).

Do I perhaps need a special comparison operator to compare non-standard
text?

Any help is appreciated!

Kris,

I can't help you myself with this problem, but I would advise you to ask
the question on the MySQL general mailing list. The MySQL developers
hang out on that list.

See <http://lists.mysql.com/mysql>

HTH,
JP

--
Sorry, <de*****@cauce.org> is a spam trap.
Real e-mail address unavailable. 5000+ spams per month.

[Brion Vibber]

Kris wrote:

Then I construct a query that looks like:

SELECT * FROM EDICT WHERE KANA=$term

Don't forget to put quotes on the string!

Hint: try searching for "KANA LIMIT 5"

-- brion vibber (brion @ pobox.com)