• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

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

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
zimmer9
Asked:
zimmer9
1 Solution
 
Joe WoodhousePrincipal ConsultantCommented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now