Japaneese Langauage matching in sql query

[habib009pk]

My dear friends,

 

I am facing a problem, I have a table which has approximately 5000 colors in japanese, english and russian language and each color has a reference number. Now i want to pick this reference number and color name in english and want to dump in another table. I have only color in japanese language for the comparison.

 

Now i am using this query:

 

SELECT color_id, name_en from tblcolors where name_jp ='$color_japan'

 

where $color_japan having string in japanese chracters. But when i am running this query it is not comparing with the colors table.

 

Kindly help me how can i get my desired result.

 

Waiting for my reply

 

Thanks and Regards

[Mchl]

What encoding do you use for data storage and connection to database?

[habib009pk]

Hi Thanks for replying

 

we are using Collation binary for the table, and datatype of this feild is varbinary.

 

Best Regards

[Mchl]

And connection encoding?

 

Should be set to be the same as your database encoding and your webpage encoding.

[habib009pk]

Please define how I set the connection encoding, there is still problem there I have no facility for comparing japanese string from one table to other table through sql query.

 

Kindly help me I will be very thankful to you

 

Thanks and Regards

[Mchl]

mysql_query("SET NAMES 'utf8'"); // instead of 'utf8' put your desired encoding.

[habib009pk]

Is it correct or where i can place you given statement

 

------------------------------------------------------------------

mysql_select_db($database_kansai, $crawler);

$query_rscolor = "SELECT color_id, name_en from tblcolors where name_jp ='$color_japan'";

mysql_query("SET NAMES 'utf8'");

$rscolor = mysql_query($query_rscolor, $crawler) or die(mysql_error());

$row_rscolor = mysql_fetch_assoc($rscolor);

------------------------------------------------------------------

[Mchl]

Preferably right after mysql_connect(), but in general before any queries you want to use this encoding.

 

The code you posted above shoud work ASSUMING that your HTML is encoded in utf8 AND your MySQL tables use utf8 for storage.

[habib009pk]

No luck, The query giving zero result, I concerned with my japanese language friend and he is saying that their is too much words same in both of table. But the query giving no +ve result.

 

Thanks and Regards

[habib009pk]

Is any other thing we will try??

[fenway]

Is any other thing we will try??

There's nothing else to "try" -- the instructions above actually work.