Hi, I suggest to use VARCHAR without size limitation. The only problem is: this will not work on other databases except HSQLDB and SQLite. Example:
CREATE TABLE TEST(ID INT, URL VARCHAR); Regards, Thomas On Wed, Dec 17, 2008 at 3:12 PM, Dhruv Patel <[email protected]> wrote: > > can any body help me suggesting column size for url. > > my certain functionality need search on url. > > can anybody suggest idea to store actual URL and search both > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
