SQL Field nvarchar(300) getting back unicode encoded memo 1

[eric0524]

SITUATION:
I am working with a select statement calling from sql 2008 that pulls two fields from SQL ent_num, int and sdn_name nVarChar(300). When I get me result set back the sdn_name is a memo field and on top of that it is unicode. I was doing a:

SELECT sdndata
replace sdndata.sdn_name WITH STRCONV(sdndata.sdnName,6)while !EOF()

this converts the memo to something I can read.

QUESTION:
Is there a different way to make my sql call that will return my memo fields as ascii rather then doing a find an replace on the unicoded memo fields?

Right now I call:

select * from sdndata into cursor csdndata


-Eric

 

[Olaf Doschke]

Welcome, Eric!

1. The n in nvarchar means it's unicode. See Sys(987) to get values translated to ansi (as far as possible)
2. Only up to 254 chars will be put in VFP varchar or char fields. Memo is normal.

As you can live with memo results setting SYS(987,.t.) should be all you need.

Bye, Olaf.

 

[eric0524]

Olaf
That worked.
Thanks,
Eric