1. Home
  2. Development
  3. RE: Problem with Arabic translation in page name(??????)

RE: Problem with Arabic translation in page name(??????)

thumbnail
Gabriel Bustos Padilla, modified 10 Years ago.
Problem with Arabic translation in page name(??????)
Junior Member Posts: 63 Join Date: 3/6/13 Recent Posts
Hi! I have a problem in my production machine because when I try to introduce the arabic translation in page name, appears "??????" instead of the arabic translation. What could be the problem?

Thanks in advance

Attachments:

thumbnail
Gabriel Bustos Padilla, modified 10 Years ago.
RE: Problem with Arabic translation in page name(??????)
Junior Member Posts: 63 Join Date: 3/6/13 Recent Posts
I have investigated and is not a problem of the charset of database. If I write the arabic characters directly in DB, when I load the page, appears correctly. The problem is that Liferay save the arabic values like ?????. With chinese characters happens the same.
thumbnail
Abdollah Esmaeilpour, modified 5 Years ago.
RE: Problem with Arabic translation in page name(??????)
Junior Member Posts: 60 Join Date: 8/22/09 Recent Posts
I had a similar problem. I figured out that collation of columns name and title of table Layout is SQL_Latin1_General_CP1_CI_AS. They need to be SQL_Latin1_General_CP1256_CI_AS to show Arabic (and also Persian) page names correctly. So I used the following queries to modify their collation:
ALTER TABLE Layout ALTER COLUMN title varchar(2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
ALTER TABLE Layout ALTER COLUMN name varchar(2000) COLLATE SQL_Latin1_General_CP1256_CI_AS

Then I modified the name of the page and the problem was resolved. Never ever modify the database manually. It causes Liferay indexes get invalidated and it can make problems.
thumbnail
Olaf Kock, modified 5 Years ago.
RE: Problem with Arabic translation in page name(??????)
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts
Ideally, you'd set every encoding on every level to UTF-8