Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 19th, 2004, 03:08 AM
Authorized User
 
Join Date: Jul 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database max only allow 255chars, i need more!

hi everyone,
i am new here...
currently i have a project which require me to store more than 255chars that the database offers.
Is there any way that i can save more than 255 chars in the database?

__________________
Snowydust
 
Old July 19th, 2004, 04:47 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 105
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Of Course there is...

I guess that the type of the field is VarChar (or something like that). That`s why you have bot only 255. Try to change the type of the field in something else.
I would be more helpful if I knew which db you use... So if you need more help give us more information about your project.

 
Old July 19th, 2004, 04:53 AM
Friend of Wrox
 
Join Date: Jun 2004
Posts: 331
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to qazi_nomi
Default

Dear snowydust
If you are using access then you should use Memo data type

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!
 
Old July 19th, 2004, 05:21 AM
Authorized User
 
Join Date: Jul 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hey..

Thanks guys...

it works when i change the field to memo using ms access.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Max length venkata MySQL 2 May 3rd, 2006 12:39 AM
MAX Query zaeem Classic ASP Databases 1 April 12th, 2005 03:16 AM
How to get max value within same id jackps SQL Server 2000 1 January 20th, 2004 07:26 AM
How to select Max hosefo81 MySQL 0 November 25th, 2003 10:27 PM
how to select Max hosefo81 PHP Databases 0 November 21st, 2003 12:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.