<div>
Not sure how oracle handles it, but SQL Server will automatically conver the data-types if you issue an ALTER TABLE statement or change the structure through EM manager.<br />
<br />
You should be ok since you are increasing the size of a field and converting a number to a string. &nbsp;You would probably have more problems if you were decreasing the size of a field or converting a string to a number.<br />
<br />
Brett
</div>


Not sure how oracle handles it, but SQL Server will automatically conver the data-types if you issue an ALTER TABLE statement or change the structure through EM manager.

You should be ok since you are increasing the size of a field and converting a number to a string.  You would probably have more problems if you were decreasing the size of a field or converting a string to a number.

Brett

<div>
for oracle<br />
<br />
alter table &lt;tablename&gt; modify &lt;coloumn name&gt; varchar2(20);
</div>


for oracle

alter table <tablename> modify <coloumn name> varchar2(20);

<div>
<div class="content wysiwyg-content">
If I has a table with a field <br />
&nbsp; &nbsp;1) length = 10<br />
&nbsp; &nbsp;2) type = int<br />
the table contains some data.<br />
Now, I decide to change the field<br />
&nbsp; &nbsp;1) length = 20<br />
&nbsp; &nbsp;2) type = varchar<br />
<br />
Can I change the field length/type without lossing my data inside the table ?<br />
Assume I use Oracle or MsSQL databse.
</div>
</div>


If I has a table with a field 
   1) length = 10
   2) type = int
the table contains some data.
Now, I decide to change the field
   1) length = 20
   2) type = varchar

Can I change the field length/type without lossing my data inside the table ?
Assume I use Oracle or MsSQL databse.

Change field length or type in a database

A font is a particular size, weight and style of a typeface. Each font is a matched set of type, one piece (called a "sort") for each glyph, and a typeface consists of a range of fonts that share an overall design. With the advent of digital typography, font is frequently synonymous with typeface, although the two terms do not necessarily mean the same thing. In particular, the use of "vector" or "outline" fonts means that different sizes of a typeface can be dynamically generated from one design. Each style may still be in a separate "font file" -- for instance, the typeface "Futura" may include the fonts "Futura roman", "Futura italic", "Futura bold" and "Futura extended" —- but the term "font" might be applied either to one of these alone or to the whole typeface.

Fonts Typography

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.