Joomla Templates Club 406,261 posts

[byjup Friend byjupJoin date: June 2008Posts: 16Downloads:0Uploads:0 Thanks: 3]

#129696

I am trying to create a website with a language other than English.
When creating an article, I am able to change the language on the article body.
But I am not able to change the language of the title.

So when I publish, I get a title, which is garbage and article in the international language.

Can somebody help. Thanks.

Philip

[VisiGod Friend VisiGodJoin date: January 2006Posts: 538Downloads:0Uploads:4 Thanks: 76 Thanked: 138 times in 18 posts]

#253594

Are you using Joomla! 1.0?

[byjup Friend byjupJoin date: June 2008Posts: 16Downloads:0Uploads:0 Thanks: 3]

#253652

Using Joomla 1.5

[VisiGod Friend VisiGodJoin date: January 2006Posts: 538Downloads:0Uploads:4 Thanks: 76 Thanked: 138 times in 18 posts]

#253656

I think your database does not support UTF-8
Could you open it via phpMyAdmin, go to operations and see if the charset is utf_general_ci

[byjup Friend byjupJoin date: June 2008Posts: 16Downloads:0Uploads:0 Thanks: 3]

#253678

These are the setting of charecter set for mysql db

character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

[byjup Friend byjupJoin date: June 2008Posts: 16Downloads:0Uploads:0 Thanks: 3]

#253679

I have not installed any language package, because there is no laguage package yet for our language.
But the article body looks fine. The only problem is with the title of article.

[VisiGod Friend VisiGodJoin date: January 2006Posts: 538Downloads:0Uploads:4 Thanks: 76 Thanked: 138 times in 18 posts]

#253686

These MUST be all in utf_general_ci.

Language packs does not have impact on that. After changing the charset, you need to re-enter the titles manually.

[byjup Friend byjupJoin date: June 2008Posts: 16Downloads:0Uploads:0 Thanks: 3]

#253725

How do u chage the charecter set for the tables and which tables.
Thanks for your help.

[bennitos Friend bennitosJoin date: May 2008Posts: 1717Downloads:0Uploads:39 Thanks: 39 Thanked: 474 times in 407 posts]

#253726

What language you want to convert it to?

[byjup Friend byjupJoin date: June 2008Posts: 16Downloads:0Uploads:0 Thanks: 3]

#253736

I want to convert it to malayalam.
here is the site http://71.228.66.219/joomla/

The table and coloums are utf_general_ci.

Output from SQL command SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name = ‘title’; ..

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT

goodnews jos_categories title 3
NO varchar 255 765

utf8 utf8_general_ci varchar(255)

select,insert,update,references

goodnews jos_content title 2
NO varchar 255 765

utf8 utf8_general_ci varchar(255)

select,insert,update,references

goodnews jos_menu_types title 3
NO varchar 255 765

utf8 utf8_general_ci varchar(255)

select,insert,update,references

goodnews jos_modules title 2
NO text 65535 65535

utf8 utf8_general_ci text

select,insert,update,references

goodnews jos_polls title 2
NO varchar 255 765

utf8 utf8_general_ci varchar(255)

select,insert,update,references

goodnews jos_sections title 2
NO varchar 255 765

utf8 utf8_general_ci varchar(255)

select,insert,update,references

goodnews jos_weblinks title 4
NO varchar 250 750

utf8 utf8_general_ci varchar(250)

[byjup Friend byjupJoin date: June 2008Posts: 16Downloads:0Uploads:0 Thanks: 3]

#253790

Solved the problem.
I changed the font-family variable in /joomla1.5/templates/ja_teline_ii/css/template.css to ML-TTRevathi

Now I see everything in ML-TTRevathi. Thank you all for your efforts.

[Author]

Posts