left zeros disapear ???

[RicardoPereira]

I have a search page that gets data from an sql server database. My problem is when i search values with left zeros in the begin of the string, they simple disapear.
Example: if i have in the database this string "010505" it appear like "10505".
Why did this happen ?

Thanks
Ricardo

 

[vbkris]

because its a numeric field (i guess), if the database field is varchar in nature that wont happen...

Known is handfull, Unknown is worldfull

 

[RicardoPereira]

It is defined as a varchar ...

 

[venur]

Hi,

This is what might be happening while you are reading for the database

 String intValue = "01234";
 System.out.println("intValue as int |" +Integer.parseInt(intValue));
 System.out.println("intValue as String |" +intValue);

 /*
  output is
  intValue as int |1234
  intValue as String |01234
 */

Cheers
Venu

 

[RicardoPereira]

I think that the problem is when i request the parameter.
When i request the parameter 010101 it only assumes 10101.

 

[RicardoPereira]

If the field is numeric how do i solve this problem ?
How can i put the left zero in the database ?

Thanks

 

[jemminger]

if that column in the database is defined as varchar, then most rdbms's define a function for "padding" or "stuffing" characters.

http://www.windowsitpro.com/Article/ArticleID/14215/14215.html

-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }
i like your sleeves...they're real big