Text in Hebrew saved as question marks

Hi

Can you send me sample Hebrew text so that I can check and let you know.

Thanks

Sure:

??? ????? ???? ??????.
????.

Thanks.

Hi

I have checked it. It is working in Hebrew language.

Have you checked your settings for UTF-8

Please goto settings–>Reading and check Encoding for pages and feeds
It must be UTF-8

Have you checked your header.php file in yout theme contains

<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ />

please check and let me know

Thanks

Hi,

I checked and the reading settings were already set to UTF-8.
I have also added the <meta…> line but with no effect.

But I think the problem is at a more basic level than the theme level because at the “Manage Scrolling News” option I write the news in Hebrew but after I save them they change into question marks, and this has nothing to do with the theme.

I have tried on both a regular English WP installation and on a Hebrew localized installation, both new, but same result.

If you managed to see Hebrew than there’s some difference between our systems.

Would it be too much to ask you to install a fresh site and see if you can still get Hebrew with your plugin?

Hi

May be your database character set problem.
It must be

character_set_client = utf8
Check it.

Thanks

Hi,

First, I should mention that my WP installation is on a local machine and is using WAMP.

I searched for the text ‘character_set_client’ through the entire WAMP directory and found it in 2 places:

1. mysql_system_tables.sql
code: ‘character_set_client char(32) collate utf8_bin’
2. fill_help_tables.sql
code: ‘character_set_client: latin1’

Do I need to change anything?
I should mention again that I see Hebrew everywhere else.

Thanks!

Hi

Could you check character set for tableprefix + scroll_news table ?

Thanks

Hi,

I’m not sure I understand the question.

The full table name is wp_scroll_news.

Thanks.

Hi

I am asking about what is character set for wp_scroll_news. table ?

Thanks

Hi,
In order to find what is the character set for this table I ran this code I found on the internet (sorry, I don’t know how to do it):

SELECT CCSA.character_set_name
FROM information_schema.TABLES T, information_schema.COLLATION_CHARACTER_SET_APPLICABILITY CCSA
WHERE CCSA.collation_name = T.table_collation
AND T.table_name = “wp_scroll_news”

and I got:
latin1
latin1
latin1

So I used this query:

ALTER TABLE wp_scroll_news CONVERT TO CHARACTER SET utf8;

Then I checked again and this time got:
latin1
latin1
UTF8

I also checked the table structure and this is the CHARACTER SET for all columns:

id
title utf8_general_ci
content utf8_general_ci
createdon
custom_link utf8_general_ci

Still getting question marks.
I restarted the server and tried writing new news.

Is there anything else I can do or check?

Thanks.

Hi,

Problem solved.

Since I made a few tries of fixing this problem I created several sites.
So when I changed the CHARACTER SET to UTF-8 it was on a different site than the one I was checking.
So now it’s alright.

I do wonder, though, how come it was not UTF8 originally after a clean installation.

Ok

Thanks for using it please rate this plugin if you like it.

Thanks

Hi,

I gave it the highest rating.

I would appreciate it though if you could check if the plugin installs with the latin character set by default instead of UTF8 as happened to me several times, and if so, it would be great if you could release an update that fixes that so I (and other Hebrew users) don’t have to fix that after each installation.

Anyway, thanks for your help and cheers on the great plugin.

How do we fix it to work in Hebrew
All we see is ??? marks
Do you have another explanation
thanks

Hello

Have you check it database ? How it is stored in database ? If it is stored as ? in database then it is likely b’cause of CHARACTER SET of column in database table of wp_scroll_news.

Thanks