Characters not show with SQL Server Table

S

sck10

Hello,

I am using SS2K. We are storing documents from html and word files into a
varchar(4000) field. The problem that I am having is that we have document
containing single quotes, left and right double quotes, comma's or ellipses
that are viewable in the table when using SQL Enterprise Manger, but only
show up as blocks when using MS Access.

I found that if I paste them into a native table, the characters show
correctly. Is there a solution to this problem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top