Skip to main content

Varchar(-1)


Today we are going to discuss about the varchar(-1). why we are using varchar(-1) and what is the purpose of it.

Varchar(-1)


In case if we user doesnt know the column length. how many character will user enter: so it is better to go with vachar(-1)


Consider the column address is of varchar(-1), now in case 1 when user enter a data of size varchar(10) the size of the column dynamically accepts the user data of size varchar 10. later in case 2 user tries to insert data of size varchar 100. now the column address can accept user data of size 100. 

NOTE: The size of the column will change automatically when user tries to insert a data of size greater than previous inserted data.
Labels:

Popular posts from this blog

CONVERTING TORRENT FILE TO ZIP FILE

HOW TO CONVERT TORRENT FILE TO ZIP FILE 1>>click the link below  http://www.zbigz.com   2>>upload your .torrent file  3>>wait until conversion, after conversion your  file can be downloadable in .zip format.
Read more

Responsive PanelGrid in JSF Primeface

Here, we are going to learn about responsive PanelGrid in JSF Primeface component. As we know primefaces providing lots of good stuffs for JSF. In Primeface, there is a component name Panel Grid which we are going to use for our convenience. In most of the cases, PanelGrid used for making our content in a proper way. If users opens our website which we have made in jsf using panelGrid component that not in responsive manner, that could be really ugly as for as user concern, So here we are going to break it just by using Layout attribute in the panel Grid component. for exaple, < h3 >Responsive</ h3 > < p:panelGrid columns = "3" layout = "grid" >                 < h:outputText value = "Content" />      < h:outputText value = "Content" />      < h:outputText value = "Content" />      < h:outputText value = "Content" />      < h:outputText value = "Content" />
Read more

How to clear Filter value in Primefaces Datatable?

As we Know, primefaces provides plenty of components for JSF. In this discussion, we are going to uncover filter attribute mystery in Datatable. Above the pic represents the filter option which is available in primeface . we can easily inherit filter option to datatable. PROBLEM WE FACE: while doing filter in datatable primeface, if we want to go further action. for example, you have 1000 of records, you're filtering option to filter those records. while filtering, you have seen your records and you need to go another action, at the time filter wont be clear. it will be remains same. Inorder to overcome that issue, we need to use below scripts, RequestContext.getCurrentInstance().execute("PF('any_name').clearFilters()"); Add widgetwar attribute in your datatable component <p:datatable id="d_id"   widgetVar ="any_name">
Read more