SQL data type ntext

PeterTom

I can asign the value of a sql field type = ntext to a Navision variabel type Variant and it has the correct value, but when I try to convert this variant to text or bigtext it gets this value ¤ (char 164)

Is it because Navision cant find the end of the string ? And how do i solve this ?

regards

Peter

todro

PeterTom wrote:

I can asign the value of a sql field type = ntext to a Navision variabel type Variant and it has the correct value, but when I try to convert this variant to text or bigtext it gets this value ¤ (char 164)

Is it because Navision cant find the end of the string ? And how do i solve this ?

regards

Peter

Ntext stores the data in unicode format (2-byte), so does the variant. Use text instead of ntext. How do you access the ntext field ?