google.com, pub-5747754088801811, DIRECT, f08c47fec0942fa0 Skip to main content

How to check database , table , column charset and collation in mysql workbench

Mysql workbench have facility to schema inspector. You get database , table , column about charset and collation.

1 To check it in Mysql workbench right click on schema there is option of Schema inspector click over it.


2 You can check all the detail of schema.



3 Tables

4 Column


etc.

Comments

Popular posts from this blog

Liferay portlet with alloy Ui form validator example.

 Alloy Ui  is built on YUI and we can use it in our liferay portlets.  Yui provides many component which are easy to use in our portlets  Here we see basic form validator.example with liferay portlet. Create portlet AlloyUi-portlet in eclipse. Add below content in view.jsp file Here we create two link for two JSP. <%@ taglib uri="http://java.sun.com/portlet_2_0" prefix="portlet" %> <script src="http://cdn.alloyui.com/2.5.0/aui/aui-min.js"></script> <link href="http://cdn.alloyui.com/2.5.0/aui-css/css/bootstrap.min.css" rel="stylesheet"></link> <portlet:defineObjects /> <portlet:renderURL var="basicform"> <portlet:param name="mvcPath" value="/BasicFormValidatorExample.jsp"/> </portlet:renderURL> <portlet:renderURL var="fullform"> <portlet:param name="mvcPath" value="/FullFormValidatorExample.jsp"/> </portlet:re...

Start open office in linux through command for liferay

Some time liferay not generate preview and not allow conversion from word to pdf etc. The reason can be it is not started with root access. Please fire below command to start soffice with the root access. First Kill the soffice proccess. pkill -9 soffice Execute below command to run it sudo soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard &