Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving unicode data
Message
 
 
To
26/12/2011 12:39:41
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01531693
Message ID:
01531696
Views:
70
>You might look at this http://www.west-wind.com/presentations/foxunicode/foxunicode.asp
>
I actually read this article couple of times, but I still can not achieve the desired result.

I have data correctly saved in the nvarchar(100) fields. In SSMS I can do
update dbo.Prefs_sl set language00 = N'ʕʒϿ'
and all is well.

Now, in VFP I retrieve the data using
select cast(language00 as varbinary(max)) as language00
So far so good. I created a class with MS Forms2 ActiveX control and I can directly assign that prefs_sl.language00 to the control. See attached screen.

However, I can not figure out how to save it back. I've tried various code from the article and so far nothing worked.

May be someone can try the same experiment as I did and tell me what I'm missing?

Here is what I tried in the Change event of the control:
LOCAL lcText
lcText = STRCONV(this.Text,10) 
=MESSAGEBOX(m.lcText)
lcText = CREATEBINARY(m.lcText)
=MESSAGEBOX(m.lcText)
_cliptext = m.lcText
replace (this.parent.LanguageField) WITH m.lcText
I've tried strconv(this.text,11) also.

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform