Please Help on Saving Contents in Non-English language!

adams950's picture

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

vividvilla's picture

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

adams950's picture

Thank you very much for your quick reply!

I'll check it.

More guide please?

adams950's picture

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

kevinsiji's picture

Can you quote the error what you are getting. A screen shot will be very good.

kevinsiji

The Error is: PDOException:

adams950's picture

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

kevinsiji's picture

http://drupal.org/node/1100146

This first 4 comments will hopefully help you to solve the issue.

kevinsiji

Thanks!!!

adams950's picture

Thank you very much kevinsiji!

I'm checking ...

Have a nice day!

Hi!I have converted each

adams950's picture

Hi!

I have converted each table to unicode manually with:

ALTER TABLE table DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci

Conversion success! results like:
ALTER TABLE table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;# 7 rows affected.

No use! then I tried:

ALTER TABLE table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Conversion 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?

Translations

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week