Hi Niranda, IMO we should fix this properly, by setting the type to VARCHAR(255) rather than VARCHAR(256) for fields with unique indices, in the place where the tables are created. This is because we can't mandate users to have a specific character set (especially latin1). Setting the engine to MyISAM during table creation would also solve this but that is also not recommended.
Thanks, On Monday, 7 September 2015, Niranda Perera <[email protected]> wrote: > HI Hemika, > > it worked! thank you :-) > > On Mon, Sep 7, 2015 at 12:19 AM, Hemika Kodikara <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> Hi Niranda, >> >> As far as I can remember this is coming due to a db collation issue. >> >> You can fix it by changing Collation from UTF-8 to latin. >> >> ex : >> create database <DATABASE_NAME> character set latin1; >> >> Regards, >> Hemika >> >> Hemika Kodikara >> Software Engineer >> WSO2 Inc. >> lean . enterprise . middleware >> http://wso2.com >> >> Mobile : +94777688882 >> >> On Mon, Sep 7, 2015 at 12:09 AM, Niranda Perera <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >> >>> Hi all, >>> >>> I'm testing DAS 3.0.0 in the windows env (windows 8.1 & java 1.8.0) with >>> MySQL as the carbon_db. >>> >>> I tried, executing the mysql setup dbscript and I get the following error >>> >>> 23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON >>> REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified key >>> was too long; max key length is 767 bytes 0.078 sec >>> >>> this error has already been reported [1] and when I check the script >>> also, it mentions this CARBON JIRA. >>> >>> however, this error does not occur in the linux (ubuntu) env. >>> >>> would like to know how to proceed with this? >>> >>> rgds >>> >>> [1] https://wso2.org/jira/browse/CARBON-5917 >>> >>> -- >>> *Niranda Perera* >>> Software Engineer, WSO2 Inc. >>> Mobile: +94-71-554-8430 >>> Twitter: @n1r44 <https://twitter.com/N1R44> >>> https://pythagoreanscript.wordpress.com/ >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');> >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> > > > -- > *Niranda Perera* > Software Engineer, WSO2 Inc. > Mobile: +94-71-554-8430 > Twitter: @n1r44 <https://twitter.com/N1R44> > https://pythagoreanscript.wordpress.com/ > -- Gokul Balakrishnan Senior Software Engineer, WSO2, Inc. http://wso2.com Mob: +94 77 593 5789 | +1 650 272 9927
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
