You know about SYS(987,.T.) in VFP 9, right? It will map ANSI to Unicode and vice versa for SQL Passthrough and remote SQL connections. So as long as you can represent the captured Unicode input as ANSI text you'll be Ok (IOW, if the the character set you're running VFP in can represent the entered characters).

Unicode usage generally only makes sense if you need to display/edit multiple different character sets simultaneously.

+++ Rick ---

>Hi everybody,
>
>I am using MS Forms 2 Textbox control. I found that I can select cast(nvarcharField as varbinary(max)) and directly assign to the text property and it works.
>
>Now, I am wondering how can I save the values? I tried assigning the text property directly to the field and then
>
>

> UPDATE dbo.prefs_sl 
>     SET defltlang = ?prefs_sl.DefltLang,
>     language00 = cast(?prefs_sl.language00 as nvarchar(100)),
>     lngimage00 = ?prefs_sl.lngimage00,
>     language01 = cast(?prefs_sl.language01 as nvarchar(100)),
>     lngimage01 = ?prefs_sl.lngimage01,
>     language02 = cast(?prefs_sl.language02 as nvarchar(100)),
>     lngimage02 = ?prefs_sl.lngimage02,
>     language03 = cast(?prefs_sl.language03 as nvarchar(100)),
>     lngimage03 = ?prefs_sl.lngimage03,
>     language04 = cast(?prefs_sl.language04 as nvarchar(100)),
>     lngimage04 = ?prefs_sl.lngimage04,
>     language05 = cast(?prefs_sl.language05 as nvarchar(100)),
>     lngimage05 = ?prefs_sl.lngimage05,
>     language06 = cast(?prefs_sl.language06 as nvarchar(100)),
>     lngimage06 = ?prefs_sl.lngimage06,
>     language07 = cast(?prefs_sl.language07 as nvarchar(100)),
>     lngimage07 = ?prefs_sl.lngimage07,
>     language08 = cast(?prefs_sl.language08 as nvarchar(100)),
>     lngimage08 = ?prefs_sl.lngimage08,
>     language09 = cast(?prefs_sl.language09 as nvarchar(100)),
>     lngimage09 = ?prefs_sl.lngimage09,
>     language10 = cast(?prefs_sl.language10 as nvarchar(100)),
>     lngimage10 = ?prefs_sl.lngimage10

>
>However, this doesn't seem to work as the field get converted to something else.
>
>I am wondering, if there is a step missing here. Say, may be I need to do something when assigning text property of the ActiveX back to cursor's memo field.
>
>Does anyone here have experience displaying and saving unicode data in VFP form?
>
>Thanks in advance.