+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 > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
