problem with inserting chinese character into mysql 4.1

[Zhong Yuan Lu]

Hey all,

I got a problem with inserting chinese character from jsp into the mysql4.1 through the jdbc. i developed a j2ee application in local machine with mysql 5. it works fine because i set the character set default to utf8 when i create the mysql server instance.

because my web hosting provider can only support the mysql 4.1 and then the problem occurs... (chinese character confusion now).

through the phpadmin... i have almost tried everything and it does not work. using phpdamin.... i am able to insert chinese character into the mysql database and it displays correctly either through the phpadmin or website... but if i insert
chinese character through jdbc and it becomes confusion (they didnot disply quesiton mark "?" but some other marks such like ' ) .. ).

I noticed that i am using the older verion mysql driver starting with org.gj....somthing in my local machine and i am using latest driver (com.mysql.jdbc.Driver) provided by my web hosting company ...
i know there is possible that it is connection problem... then i put the "set names 'utf8'" before i excuting any insert command.... and it still does not work....

two problems:
1. because i am unable to modify the my.ini or my.cnf in my web hosting company mysql server and i try the command "show variables like 'char%'" before and after i successfuly set these variable to utf8 and utf_general_ci through the phpadmin, the phpadim.. shows each variable value as "BLOB something". apperantly nothing changes... does it mean the variable does not change

2. this is at moment what i am suspecting ... it is jdbc problem ..because i am able to insert chinese character through the phpadmin.... but unable to insert it through the jdbc driver..


Please help me ... my email number is ([e-mail])

Zhong Yuan Lu