Parse SQL field definition string

IN PROGRESS
Bids
11
Avg Bid (USD)
$35
Project Budget (USD)
$30 - $40

Project Description:
I need Java source code for a function that can take a string that is assumed to be a single field definition from a SQL DDL create table statement and return a java object with the following information parsed from the DDL for the field.:

1) the data type as a string (i.e. 'char', 'varchar', 'text'. 'int', 'integer', 'bigint', etc., etc.)
2) the size as an integer when applicable, null if not applications. For example, if the data type is a char then how many characters is it defined to be? If the data type is a float then how many bytes is it defined to be. (note, if the size is not explicitly defined in the DDL then this can be null)
3) a string containing any DDL about the field other than it's type and size. For example, DDL for nullability, defaults, foreign key, etc. should all be returned as a string that could be post fixed to the type and size definition if the DDL for the field were to be recreated.
4) a Boolean set to false if the field allows null values and true if it does not (false should returned if not explicitly stated in the DDL)
5) a string containing the "Default" value if one is defined. NULL if no default is defined.

The function should also accept a "dialect" indicator as a string with at least the following possible values:
1) "MSSQL"
2) "Access"
3) "MySQL"
4) "SQLite"
5) "PSQL"

Where the dialiect code correspond to:
1) "MSSQL" - Microsoft SQL Server T-SQL
2) "Access"- Microsoft Access
3) "MySQL" - MySQL
4) "SQLite" - SQLite
5) "PSQL" - Postgres SQL

The function must properly parse at least each of the 5 dialects listed.

Skills required:
Java, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 40
in 1 days
Hire poornachand
$ 40
in 2 days
Hire csanuragjain
$ 40
in 7 days
Hire omniaibrahim
$ 30
in 3 days
$ 40
in 2 days
$ 30
in 2 days
$ 40
in 1 days
Hire melenlu
$ 40
in 1 days
Hire jfrenetic
$ 30
in 1 days
Hire NatashaPl
$ 30
in 5 days