error charset even set UTF-8

[bui viet phuong]

i had a server, i got a error in Vietnamese language since version 4.1
i had a technician guide me set in mysql.cnf
------------
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server = utf8
-------------
that was fine, website run very well with Vietnamese, however some of my websites moved to another hosting service (not in my server anymore) so it got trouble
because the server default : latin1_swedish_ci
i tried to set charset and collation directly in phpmyadmin and SSH for client
unfortunately was not fixed, setting for client level was not enough . while hosting provider did not agree to change the system to utf-8 in mysql.cnf
currently
database's collation utf8_general_ci (absolutely utf8 in the whole database and in each table)
but server's collation: latin1_swedish_ci

i can see Vietnamese in this database very well in phpmyadmin but it is error in website
for example in phpmyadmin, i can read:
"cuộc sống mến yêu"
in website: Cu?c s?ng m?n y�u!
help me, how to run my curent database with utf8_general_ci but in "latin1_swedish_ci " server



Edited 2 time(s). Last edit at 02/05/2007 06:18AM by bui viet phuong.