Hi all, thanks for the feedback.
I think this should be changed kernel wide. pls follow the thread [1] cheers [1] [Dev] [Carbon] mysql dbscripts using values > 255 for varchar for unique keys On Mon, Sep 7, 2015 at 3:37 PM, Aiyadurai Rajeevan <[email protected]> wrote: > +1 for Gokul suggestion(VARCHAR(255)) > > I had same issue and fixed it by changing to VARCHAR(255) > > Thanks & Regards, > S.A.Rajeevan > Software Engineer WSO2 Inc > E-Mail: [email protected] | Mobile : +94776411636 > > On Mon, Sep 7, 2015 at 12:51 AM, Gokul Balakrishnan <[email protected]> > wrote: > >> 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]> >>> 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]> >>>> 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] >>>>> 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 >> >> > -- *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] http://wso2.org/cgi-bin/mailman/listinfo/dev
