Journal content in Hindi language[Resolved]

[Rishi Dev Gupta, módosítva 15 év-val korábban]

Hi

I am working on an application that works in English and Hindi languages.
I have journal content portlets where I want to put in the hindi text. As soon as I click on save button while editing an article, the server throws an error on the log console

06:59:29,693 ERROR [JDBCExceptionReporter:78] Data truncation: Data too long for column 'content' at
row 1
06:59:29,708 ERROR [AbstractFlushingEventListener:301] Could not synchronize database state with ses
sion
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.j
ava:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE
ventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:
27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at com.liferay.portal.dao.orm.hibernate.LiferaySession.flush(Unknown Source)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(Unknown Source)
at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.updateImpl(
Unknown Source)
at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.update(Unkn
own Source)
at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.updateArticle(Unk
nown Source)
at com.liferay.portlet.journal.service.impl.JournalArticleServiceImpl.updateArticle(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310
)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMe
thodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte
rceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy259.updateArticle(Unknown Source)
at com.liferay.portlet.journal.service.JournalArticleServiceUtil.updateArticle(Unknown Sourc

I have translated the text from English to Hindi in Google language translator and copy & paste in to WYSWYG editor of liferay.

I have made the entry for language in portal-ext.properties

locales=hi_IN,en_US

and select the language from drop down.

Also in the database charaterset is utf8 and collation as utf8_bin.

Please help, if I am missing any other configurations.

ऋषि देव गुप्ता

[Rishi Dev Gupta, módosítva 15 év-val korábban]

Figured out the solution to problem.

the MYSQL server was taking "latinl" as default character set.
I have reinstalled the databse with utf8 characterset only then it worked.

Cheers ALL!

[bhaskar apparao varada, módosítva 14 év-val korábban]

Rishi Dev Gupta:

Figured out the solution to problem.

the MYSQL server was taking "latinl" as default character set.
I have reinstalled the databse with utf8 characterset only then it worked.

Cheers ALL!

Hi Rishi,

Can you please tell me how did you add the new language hindi in to liferay
which process you have used for this.

Can you please tell me how did you impliment this.

Thanks,
Bhaskar V.

[Rishi Dev Gupta, módosítva 14 év-val korábban]

Introducing new language is not very complicated task.

Just follow the wiki articles available here.

Try this

http://www.liferay.com/community/wiki/-/wiki/1071674/Translating+Liferay+to+a+New+Language/maximized

[Baji Shaik, módosítva 13 év-val korábban]

Hi Rishi,

Please suggest me how to display hindi content on portal. what is the encoding mechanism used for hindi in native file of liferay 6.0.

Thanks in advance.

[Baji Shaik, módosítva 13 év-val korábban]

Hi Rishi,

How to convert hindi text into the following format/encoding mechanism. what is that mechansim/ encoding technique using.
ex:हà¥~Gलà¥~Mप

Thanks

[Rishi Dev Gupta, módosítva 13 év-val korábban]

Follow the steps written in my above posts and you can make any language working,

[Jigna parag Joshi, módosítva 13 év-val korábban]

i have set my locale france..and now i also want to store my data in france..but it is not storing correct data..i have inputted "Français Interest" in interest field in MyAccount.

but, when i see in HttpAnalyzer.it is showing me Français Interest</color>.
and also it is storing same in DB.

please let me know if any configuration need to be done from my side..

thanx in advance..

regards
Jigna Joshi

[Rishi Dev Gupta, módosítva 13 év-val korábban]

Is your mysql or DB you are using configured for UTF-8 character set, if not then you need to do it, then try french characters.

[Manish Kumar Jaiswal, módosítva 13 év-val korábban]

Dear Rishi ,

Can we also translate the title of web content ...I am also trying to do the same (make hindi/english work) but only contect has the facility to be written into any language but not the title.

[mohammad azaruddin, módosítva 10 év-val korábban]

HI all we need to add new entry in web.xml...so can we achive this via hook.................?