CODEWITHSUNDEEP
liferayliferay-6liferay-ide
Munadel
Munadel

Reputation: 107

custom fields liferay language support

I have custom field with input text. I have added arabic language support in control panel

but when I insert an arabic word it says Users and Organizations is temporarily unavailable.

How to solve this issue?

This is what happened in console log:

10:29:49,421 ERROR [http-bio-8080-exec-17][JDBCExceptionReporter:82] Incorrect string value: '\xD8\xB9\xD8\xB1\xD8\xA8...' for column 'data_' at row 1
10:29:51,254 ERROR [http-bio-8080-exec-17][render_portlet_jsp:132] null
java.sql.SQLException: Incorrect string value: '\xD8\xB9\xD8\xB1\xD8\xA8...' for column 'data_' at row 1
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
    at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
    at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
    at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2412)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2875)
    at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)

Upvotes: 1

Views: 361

Answers (1)

adarshr
adarshr

Reputation: 62573

Take a look at http://www.codeka.com.au/blog/2014/02/unicode-support-in-mysql-is--

and https://news.ycombinator.com/item?id=7317519.

Basically it is because of the incorrect character encoding set for your database.

Upvotes: 1

Related Questions