Hi Dulanja,
Thanks for the input. As you mentioned I used the 'latin1' as a workaround
to solve this issue, last week. Then I tried other wso2 products like APIM
and ESB. All having same issue when we set the character set to 'utf8'.
That's why I got the thought "we do not support utf8" :)
@Nufail
My default DB engine is 'InnoDB'
*************************** 8. row ***************************
Engine: InnoDB
Support: DEFAULT
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
Thanks,
Thanuja.
On Mon, Jul 14, 2014 at 11:00 AM, Dulanja Liyanage <[email protected]> wrote:
> Hi Thanuja,
>
> MySQL default character set in Linux is 'latin1'. IIRC in Windows it's
> UTF-8.
>
> This seems to be a pretty old issue and there's a resolved jira for it as
> well [1] (it's in fact pointed to by the mysql script). Apparently this is
> not fixed yet.
>
> BTW, why do you want UTF-8? One workaround for this is to use latin :)
>
> [1] https://wso2.org/jira/browse/CARBON-5917
>
> Thanks
> Dulanja
>
>
> On Sun, Jul 13, 2014 at 7:51 AM, Thanuja Jayasinghe <[email protected]>
> wrote:
>
>> Hi all,
>>
>> MySQL default character set is 'latin1' and collation is
>> 'latin1_swedish_ci'. So I change it to 'utf8' and 'utf8_general_ci' by
>> adding followings to '/etc/mysql/my.cnf' file.
>>
>> [client]
>> default-character-set=utf8
>>
>> [mysqld_safe]
>> default-character-set=utf8
>>
>> [mysqld]
>> collation-server = utf8_unicode_ci
>> init-connect='SET NAMES utf8'
>> character-set-server = utf8
>>
>> Now I'm trying to start IS-5.0.0 with '-Dsetup' option, and getting
>> following error.
>>
>> Caused by: java.lang.Exception: Error occurred while executing : CREATE
>> INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON REG_PATH(REG_PATH_VALUE,
>> REG_TENANT_ID)
>> at
>> org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQL(DatabaseCreator.java:169)
>> at
>> org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQLScript(DatabaseCreator.java:325)
>> at
>> org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:61)
>> at
>> org.wso2.carbon.user.core.common.DefaultRealmService.initializeDatabase(DefaultRealmService.java:278)
>> ... 19 more
>> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>> Specified key was too long; max key length is 767 bytes
>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method)
>> at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>
>> Does anyone know solution or workaround here, or we do not support 'utf8'?
>>
>> Thanks,
>> Thanuja.
>> --
>> *Thanuja Lakmal*
>> Software Engineer
>> WSO2 Inc. http://wso2.com/
>> *lean.enterprise.middleware*
>> Mobile: +94715979891
>>
>> _______________________________________________
>> Dev mailing list
>> [email protected]
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
>
> --
> Dulanja Liyanage
> WSO2 Inc.
> M: +94776764717
>
--
*Thanuja Lakmal*
Software Engineer
WSO2 Inc. http://wso2.com/
*lean.enterprise.middleware*
Mobile: +94715979891
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
