File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
help with basic SQL
Joined: Nov 23, 2009
Apr 11, 2010 13:44:21
hi, I have a basic doubt of SQL language structurei, look at:
bigint, int, smallint, tinyint but what is more used? varchar?
e.g: a columm with 11 numbers of identification as (CPF from Brazil) must I use int (11) or varchar (100) or another one?
Joined: Oct 13, 2005
Apr 12, 2010 03:40:57
Please explain more details. What's a CPF? If you have a fixed number of characters, particularly if they start with "000" char(11) might be a better format.
I agree. Here's the link:
subject: help with basic SQL
Dealing with results of java time code
prepareStatement returns 0?
java date format stored as varchar - need to convert it into date
SQL query not giving any result
Couldn't Load Database Driver
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015