Reading Data from SQL Table 1

[GKBray]

Hi,

I am trying to read some data from an SQL table.

I have created a connection, and a Remote View.

When I Browse the View, some of the Fields are Memo, and when I open them, the data has little Squares in between each letter.

I think I need to convert the data, but I have no clue how to, or what to convert it to.

This is my first time reading from SQL, and I am stumped.

Can someone point me in the right direction please.

Many thanks

Graham

G K Bray Programmer

 

[Mike Lewis]

Graham,

The problem is that the data on the server is stored in Unicode. The little squares are binary zeroes that represent the high-order bytes of each character.

You can easily strip out these unwanted characters. For example: STRTRAN(MymemoField, CHR(0), "")

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[GKBray]

Thanks Mike,

I'll try that.

G K Bray Programmer

 

[GKBray]

Hi Mike,

I just found this in the Help file, SYS(987,.T.), after looking up Unicode.

Thats the bit I didn't understand.

As per your other thread on VFP, long may it continue.

Thanks again

Graham




G K Bray Programmer

 

[Mike Lewis]

Graham,

I've never tried SYS(987), but it looks like it should do what you want.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk