To Use Unicode or not?

[UpstateWeb]

I am posting this to hopefully help someone else with the same problem(s) and
maybe get an answer?

I recenlty updated from 4.5 to 6.1 and have run into a few issues. The one
bugging me the most is with <cfupdate> and <cfinsert>. I know, I know - use
<cfquery>. And I have begun using them more. But for those who have hundreds of
applications using the tags, you would like to see them work.

Well I just discovered the problem. I put two and two together. When I first
switched over, a lot of my websites had square boxes [] or ? marks on some of
the pages. I read where I needed to start using MS Access with Unicode. So I
changed all my datasources from regular MS Access to MS Access with Unicode.

Now I just read where <cfupdate> will cause an error, "Application uses a
value of the wrong type for the current operation", if you are trying to update
a memo field. I change back to MS Access on my datasource and now it works -
but here are the square boxes and ? again.

Can anyone solve this ridle?

Rock Moore

[PaulH *TMM*]

UpstateWeb wrote:

> Now I just read where <cfupdate> will cause an error, "Application uses a
> value of the wrong type for the current operation", if you are trying to update
> a memo field. I change back to MS Access on my datasource and now it works -
> but here are the square boxes and ? again.
>
> Can anyone solve this ridle?

i guess the first question is what exactly is the problem? is this a
known issue? i don't really use access but i suppose you might try this
kb article: [url]http://www.macromedia.com/go/2d2a7a19[/url]