Posted by adams950 on September 23, 2011 at 7:40am
Hi!
I have posted this question on Drupal forum few days before. But I no one replies... So I want your help!
I'm using Drupal 7, works pretty on English.
But If I try to save an article or basic page in Non-English languages (like Sinhalese, Tamil, Arab, Hindi), it shows an error message and does not save.
I'm using Drupal's languages, and have tried language packs (.po) which downloaded from Drupal site.
I have installed Language and Translation modules (which come with drupal).
And the user interface works fine in that languages. But saving does not work.
I'm new to Drupal. Please explain me step by step.
PLEASE HELP ME!
Thanks in advance.
Adams
Comments
Database format
Ensure that you are using unicode format for database,without this other than english languages are not supported.Create a database with uff_8 unicode format and use this as ur drupal database.
Thank you very much for your
Thank you very much for your quick reply!
I'll check it.
More guide please?
Sorry, I've converted the drupal db via phpmyAdmin. But still that error.
I'm fearing that if I create a new drupal db, I will lose all the current data!
I knew db creation, but I don't know how to link it to drupal.
Could anyone give me some more info on above?
I'm expecting your replies!
Can you quote the error what
Can you quote the error what you are getting. A screen shot will be very good.
kevinsiji
The Error is: PDOException:
The Error is:
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xE0\xAE\xA4\xE0\xAE\xB2...' for column 'title' at row 1: INSERT INTO {node} (vid, type, language, title, uid, status, created, changed, comment, promote, sticky) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => article [:db_insert_placeholder_2] => en [:db_insert_placeholder_3] => தலைப்பு [:db_insert_placeholder_4] => 1 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 1316841022 [:db_insert_placeholder_7] => 1316841022 [:db_insert_placeholder_8] => 2 [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => 0 ) in drupal_write_record() (line 6776 of /home/netizens/public_html/tstdrp/includes/common.inc).
The website encountered an unexpected error. Please try again later.
Please note, I've given (for a test):
The Title:
"தலைப்பு" ("Thalaippu" in Tamil Language).
The Content: "செய்திகள்" ("Seydhikal").
Please help me!
http://drupal.org/node/110014
http://drupal.org/node/1100146
This first 4 comments will hopefully help you to solve the issue.
kevinsiji
Thanks!!!
Thank you very much kevinsiji!
I'm checking ...
Have a nice day!
Hi!I have converted each
Hi!
I have converted each table to unicode manually with:
ALTER TABLE
tableDEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ciConversion success! results like:
ALTER TABLE
tableDEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;# 7 rows affected.No use! then I tried:
ALTER TABLE
tableDEFAULT CHARACTER SET utf8 COLLATE utf8_general_ciConversion success. But still does not work in non-english saving!
I also tried database engine to set utf8_unicode_ci. still same error. then set to utf8_general_ci. still error....
What to do next?
There is any web or mySQL server reboot needed?