Problem with viewing mysql table in UTF-8

vitich

New member
Version 4.2
OS FreeBSD 6.3
mysql-server-5.0.67_1
Mozilla SeaMonkey 1.1.13

Database in russian language with UTF-8 (utf8_general_ci)
In phpmyadmin everything seems to be OK, but in Dadabik I got "??????????????" :(
Can you help me?
 

spuri

New member
common_start.php

$conn = connect_db($host, $user, $pass, $db_name);
//add this line
@mysql_query('SET NAMES utf8'); @mysql_query('SET CHARACTER SET utf8');
// display will be okay but saving fails, i got ? instead of special characters
 

spuri

New member
any chance to work with utf8? (read+write)
read works but write utf8 to db?

(edited: i just need to set the collation in my db and read & write works fine )



Post Edited (01-11-09 19:36)
 

egurevich

Member
What does "set the collation mean"? I am having the same issue. I fixed the read problem withthe code you posted above, except instead of utf8 I am using Hebrew. I would like to use Dadabik to write as well. How do I fix that?
Thanks
Eli
 
Top