aspose file tools*
The moose likes JDBC and the fly likes help with basic SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "help with basic SQL" Watch "help with basic SQL" New topic
Author

help with basic SQL

André Asantos
Ranch Hand

Joined: Nov 23, 2009
Posts: 234
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?

bye,
AS
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38851
    
  23
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: http://aspose.com/file-tools
 
subject: help with basic SQL