Solved

How would you store an Access 2003 memo data type field in Sybase.

Posted on 2013-12-16
1
555 Views
Last Modified: 2013-12-17
I am loading some Access 2003 tables into Sybase tables.

Of course, a Memo data type field in Access can store up to 65,536 alphanumeric characters.

How would you store a memo data type field in Sybase.
0
Comment
Question by:zimmer9
1 Comment
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 39723552
The text datatype is probably your best bet, it's for human-readable character BLOB data.

Depending on character sets etc you might need one of its variants, and if there's formatting you might need to use the image datatype instead (which is raw binary BLOB).
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sybase How do we check ASE memory in MB or Gb ? 3 2,953
Sybase memory in corresponds to sybase pagesize 4 1,326
Crystal Reports 8.5 hangs 11 95
sybase output only middle rows 4 23
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
Troubleshooting common task sequence error codes
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question