•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 456,508 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,677 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 2503 | Replies: 3 | Solved
 |
| |
•
•
Join Date: Sep 2007
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi
I've used Access to model a new database that now needs to be created in SQL Server Express.
Wow - that's alot of data types!
Can someone tell me what the SQL version of the Access Memo data type is?
Thanks
_________________
Parental control software free parental control software
I've used Access to model a new database that now needs to be created in SQL Server Express.
Wow - that's alot of data types!
Can someone tell me what the SQL version of the Access Memo data type is?
Thanks
_________________
Parental control software free parental control software
•
•
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,166
Reputation:
Rep Power: 7
Solved Threads: 59
Prior to Sql Server 2005 it would have been text or nText (the n prefix is for unicode data as opposed to ASCII data) as varchar is limited to approx 8000 chars (the max length of a row allowed and if you use it all for one varchar column you got no space left for anymore) Text fields require a little extra work in your Sql statements though 
If you mean Sql Server 2005 Express then your options are better
varchar(max) (non-unicode ASCII chars only)
nvarchar(max) (Unicode chars)
text
nText
I recommend varchar or nvarchar. If your data is all in plain english (no special chracter sets) then varchar(max) is your baby
If you mean Sql Server 2005 Express then your options are better
varchar(max) (non-unicode ASCII chars only)
nvarchar(max) (Unicode chars)
text
nText
I recommend varchar or nvarchar. If your data is all in plain english (no special chracter sets) then varchar(max) is your baby
•
•
Join Date: Aug 2008
Posts: 9
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
Does this answer apply to data types in MS SQL Server 7, also?
I'm coming from the world of MS Access and memo data type.
I'm coming from the world of MS Access and memo data type.
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode
•
•
•
•
access ajax asp avatar backup breach broadband code combo creative crime daniweb data data protection data transfer database design developer development dropdownlist forensics government hacker hardware howto ibm illustrator internet linux medicine microsoft module msdn net news normalization office photoshop print reuse security server sql storage survey toread tutorials vista web wikipedia
- DATETIME data type arithmenic in SQL Server 2005 (MS SQL)
- Working with SQL server's Image data type (ASP.NET)
- MS SQL data type length (MS SQL)
- Problems with changing values returned by RegQueryValueEx (C)
- help on data type conversion (Visual Basic 4 / 5 / 6)
- Help With Data-type Declaration Symbols (Pascal and Delphi)
- Working with SQL's Text data type (ASP.NET)
- Text data type troubles in T-SQL (Database Design)
Other Threads in the Database Design Forum
- Previous Thread: Database design for file upload solution
- Next Thread: Using .exe files on web sites as on own computer
