Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving unicode data
Message
 
 
To
28/12/2011 08:55:14
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:
01531780
Views:
46
>>>>This is how text looks before I assing the value (I set utf8 property to 1 using comprop) - see attached.
>>>
>>>
>>>(1) If your windows is not set to cyrillic, I do not think that you can use a messagebox to display cyrillic
>>>
>>
>>If I don't apply comprop(this.object, 'UT8',1), I get back (in the messagebox) all ???. If I apply that, I can get some characters back in the messagebox.
>>
>>>(2) Try to get the value back from the ms forms textbox, just assign it and get it back
>>>
>>
>>?? How? E.g. assign value of the control.text? And to what? To the variable?
>>
>>>(3) how do you get to the new value ? It should be the same as the old value if you did not edit it
>>
>>If I don't edit it and don't re-save, it remains the same. If I copy text 'Russian' from one textbox to another and attempt
>>
>>replace myField with this.text
>>
>>or replace myField with createbinary(this.text)
>>
>>or any strconv before createbinary or anything else I can think of, I can not get back the same 4 bytes per character as original and so I always end up with something different as my final result.
>
>
>and it's TWO bytes/character

From SQL Server I got 4.

Once again see attached screen in SQL Server:
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform