Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.E-journal doesn't support UTF.
I inserted created a journal in Persian language but it showed all the Persian words as ???????
Drupal and most of the modules by default support UTF. It would be a good idea to implement this feature in journal too.
Thanks in advance
| Comment | File | Size | Author |
|---|---|---|---|
| #9 | BLANK.bmp | 1.83 MB | holydrupal |
| #8 | BLANK.JPG | 52.2 KB | holydrupal |
Comments
Comment #1
romca commentedhi,
e-journal does support utf (because Drupal does). It must be a problem with database locale, because if your database has some default locale, let say iso-8859-1 and you install modules (ie. create tables), they might get latin1 locale instead of utf8. If you look at the drupal installation, you will see that create table scripts are without statements of encoding (so that admins can choose utf8_generic, utf8_czech_ci etc.) I would recommend you to change the locale for the tables, you can do so in phpMyAdmin for mysql or some other GUI.
best,
Comment #2
holydrupal commentedThank you for quick reply. I checked Mysql and it is by default is UTF-8 and the drupal tables are Collation: utf8_general_ci
but in ejournal tables Collations are latin1_swedish_ci
Do you think this is the problem? If so How could I change it?
Regards,
Comment #3
holydrupal commentedI am changing the status hope someone can solve the problem
Comment #4
romca commentedhi,
i will add the mysql comments into the schema creating table so that utf8 will be set, in your installation, go to the phpmyadmin, click on the table, then on "edit". There you can change the collation and save the table. It will be converted then.
best,
Comment #5
holydrupal commentedThank you for your support, But I knew how I could change the encoding for the fields but I don't know how to change the encoding for the tables!?
I changed the fields and the problem with encoding have solved but for the tables I couldn't figure it out?
I search in phpmyadmin for one hour but couldn't find it.
Please let me know if you need any further information.
Regrads,
Comment #6
holydrupal commentedby the way because I used utf for encoding the path of my journal become ejournal/1/_/_
May you provide a field/system readable name field for this issue?
Regards,
Comment #7
romca commentedencoding: try to follow the instructions again, it is there
or use this: ALTER TABLE `ejournal_x` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
as to the ejournal/1/_/_ :
I don't know what you mean by "field/system readable name field for this issue"
ejournal/1/_/_ - this is your first journal
ejournal/1/1/_ - this is your first issue in your first yournal and so on
Comment #8
holydrupal commentedi have another issue with this module,
what I did:
create a journal
add issue
assign the taxonomy and the content type to it
write a title and description for my article and configure the settings but after I click on submit button the page quickly goes blank. despite this problem I could see my article in content section and when I click on it a page will open which contain only the the title of the article and the time of publishing!
by the way I am receiving the email notifications regarding my journal update without any problem. it contains all the information.
Would help me with this issue too?
Comment #9
holydrupal commentedi have another issue with this module,
what I did:
create a journal
add issue
assign the taxonomy and the content type to it
write a title and description for my article and configure the settings but after I click on submit button the page quickly goes blank. despite this problem I could see my article in content section and when I click on it a page will open which contain only the the title of the article and the time of publishing!
by the way I am receiving the email notifications regarding my journal update without any problem. it contains all the information.
Would help me with this issue too?
Comment #10
holydrupal commentedThank you for the respond and the time you spend for answering my problems.
Actually again I go for the encoding issue but still couldn't find it I must ignore it :(
the fields of tables are just in utf8 encoding; (could it make a problem for me in future?)
and about the second issue I thought that the reason which e-journal insert underline "_" for the path is that my article title is written in Persian.
(In CCK if you name your groups or fields in Persian, CCK system couldn't accept the encoding and will add underline "_" or "+" instead, or sometime for preventing from this issue they provide a system readable name which couldn't consist of utf character or and its case sensitive. I thought that your module should have the same issue but hopefully not :)
I read the Readme document completely and as I said in my previous post after submitting the article the only content in my page is just a title and the time and all the page will become blank. you could refer to my attached image.
May I have your idea about this issue too?
Regards,
Comment #11
romca commentedholydrupal,
my apologies, i was extremely busy at that time and I have probably thought your issues is resolved. You should have run the sql query, that would alter the sql table. But if the columns were set to utf, that should be ok even if the table is latin.
With regard to the blank page I don't know. There could have been something which was fixed many months ago.
all the best,
roman