Re: Create Table problem
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Mon, 25 Sep 2006 16:18:30 -0400
Darren wrote:
I am trying to create a table using a query , but Access always wantsOK, I've just discovered that if I use the CHAR datatype, as in:
to make it so my text fields are padded.
I have tried using the WITH COMP keywords, this will turn on unicode
compression, but doesn't change how the field is padded.
sql = "CREATE TABLE Test (textcol char(15))"
The field seems to be fixed-length (just like sql server)
However, if I use Text(15) or VARCHAR(15), the field is variable length,
just as you want it.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Prev by Date: Re: Create Table problem
- Next by Date: Connection String to Connect a VB 6 Application to SQL Server 2005
- Previous by thread: Re: Create Table problem
- Next by thread: Connection String to Connect a VB 6 Application to SQL Server 2005
- Index(es):
Relevant Pages
|
|
