Problem with SQLITE

abhilash · by **abhilash** » Mon Feb 25, 2008 8:46 am

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

myDB.execSQL("CREATE TABLE IF NOT EXISTS "
 
+ MY_DATABASE_TABLE
 
+ " (LastName VARCHAR, FirstName VARCHAR,"
 
+ " Country VARCHAR, Age INT(3));");
Parsed in 0.029 seconds,  using GeSHi 1.0.8.4

hi i am getting errr yaar for the above statement ......... like Syntax error Vrchar.........

plusminus · by **plusminus** » Mon Feb 25, 2008 9:45 am

Hello abhilash,

that code was tested with sdk-version m3. Now we have m5.

Maybe you'll now have to write write the amount of possible chars in brackets: VARCHAR(50)
Imo: in mySQL the default-value is 255.

Regards,
plusminus

living_sword · by **living_sword** » Mon Feb 25, 2008 5:20 pm

give the full error message. also, consider using TEXT instead of VARCHAR.

res · by **res** » Mon Feb 25, 2008 5:57 pm

According to the SQlite documentation specifying a length for VARCHAR is ignored.

plusminus · by **plusminus** » Mon Feb 25, 2008 6:35 pm

res wrote:According to the SQlite documentation specifying a length for VARCHAR is ignored.

... what is the default-value then :?:

Regards,
plusminus

res · by **res** » Tue Feb 26, 2008 3:42 am

plusminus wrote:
res wrote:According to the SQlite documentation specifying a length for VARCHAR is ignored.

... what is the default-value then

Regards,
plusminus

http://www.sqlite.org/faq.html#q9

9) What is the maximum size of a VARCHAR in SQLite?

SQLite does not enforce the length of a VARCHAR. You can declare a VARCHAR(10) and SQLite will be happy to let you put 500 characters in it. And it will keep all 500 characters intact - it never truncates.

Problem with SQLITE

Problem with SQLITE

Who is online