Problem when selecting UTF-8 data with PHP
Hi, If I am querying for below on PHP select * from country_code_match where english='Cointreau' giving output as (print_r) Array ( [id] => 19 [english] => Cointreau [chinese] => ) here Chinese characters are not displaying If i am tried same query on db its giving correct output phonedb=> select * from country_code_match where english='Cointreau'; id | english | chinese ----+-----------+--------- 19 | Cointreau | 君度 (1 row) what i have to do now. I have changed required things as utf-8 in php and in vertica DSN drivermanager, locale are changed as utf-8 and in my php program I was placed setlocale(LC_ALL, 'en_US.UTF-8'); when selecting for Chinese characters using below in php select * from country_code_match where chinese='君度' nothing is displaying
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.