shedokan Posted November 8, 2007 Share Posted November 8, 2007 I solved the problem of getting from mysql but now when I put to mysql it put's: ???'s instead of hebrew words the table is setup for hebrew so I think the problem is from the php side Link to comment https://forums.phpfreaks.com/topic/76532-solved-helpw-with-putting-hebrew-variables-to-mysql/ Share on other sites More sharing options...
~n[EO]n~ Posted November 8, 2007 Share Posted November 8, 2007 You must encode your files in utf-8 format <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> Link to comment https://forums.phpfreaks.com/topic/76532-solved-helpw-with-putting-hebrew-variables-to-mysql/#findComment-387602 Share on other sites More sharing options...
shedokan Posted November 8, 2007 Author Share Posted November 8, 2007 when I put hebrew words to mysql and then look in mysql I see ?? and all my files are already utf8 format Link to comment https://forums.phpfreaks.com/topic/76532-solved-helpw-with-putting-hebrew-variables-to-mysql/#findComment-387661 Share on other sites More sharing options...
~n[EO]n~ Posted November 8, 2007 Share Posted November 8, 2007 Then what is the problem ??? Link to comment https://forums.phpfreaks.com/topic/76532-solved-helpw-with-putting-hebrew-variables-to-mysql/#findComment-387667 Share on other sites More sharing options...
shedokan Posted November 8, 2007 Author Share Posted November 8, 2007 that when I put from php to mysql it changes the hebrew to ??? here is an example of a query: "INSERT INTO news (text, date) VALUES ('$_GET[text]', '$_GET[date]')" here is an example of $_GET[text]:"הנה כמה חדשות" here is an example of $_GET[date]:"נכתב ביום חמישי ה-8 לנובמבר 21:58:31" Link to comment https://forums.phpfreaks.com/topic/76532-solved-helpw-with-putting-hebrew-variables-to-mysql/#findComment-387792 Share on other sites More sharing options...
shedokan Posted November 8, 2007 Author Share Posted November 8, 2007 I added this before the query: mysql_query("SET NAMES 'hebrew'"); Link to comment https://forums.phpfreaks.com/topic/76532-solved-helpw-with-putting-hebrew-variables-to-mysql/#findComment-387877 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.