I am attempting to display (and eventually enter) simplified chinese 
characters into a VO (2.8) MLE.  I am using Window Vista Ultimate, SQL 
Server (2005) as a database and regular VO Datawindows for input/display.  I 
added a MLE to a window and selected the SimSun font for the MLE.  When I 
paste the chinese characters into the MLE they display correctly.  However, 
when I save them to the database (using VO2ADO) they change to ??.  So I 
tried another tactic and pasted the chinese characters directly into the db 
column using SQL Server Management Studio.  They are saved just fine in the 
management studio but when I display them using the VO MLE they display as 
??.  Do you have any ideas on how I can accomplish this?

Thanks for any help.

-- 
Roger Lawton
Product Manager
SOMAX, Inc. 

Hi Roger,

I would try AdoVoStr2Unicode(oMLE:Text) ...for a start.


> I am attempting to display (and eventually enter) simplified chinese 
> characters into a VO (2.8) MLE.  I am using Window Vista Ultimate, SQL 
> Server (2005) as a database and regular VO Datawindows for 
> input/display.  I added a MLE to a window and selected the SimSun font 
> for the MLE.  When I paste the chinese characters into the MLE they 
> display correctly.  However, when I save them to the database (using 
> VO2ADO) they change to ??.  So I tried another tactic and pasted the 
> chinese characters directly into the db column using SQL Server 
> Management Studio.  They are saved just fine in the management studio 
> but when I display them using the VO MLE they display as ??.  Do you 
> have any ideas on how I can accomplish this?
>
> Thanks for any help.
>

-- 
Carlos Rocha

On Wed, 24 Mar 2010 21:24:35 -0400, "Roger Lawton"
<nsproger@nspsomax.com> wrote:

Hello Roger,

>I am attempting to display (and eventually enter) simplified chinese 
>characters into a VO (2.8) MLE.  

Chinese is stored as double byte characters. So you won't store what
you get from common controls. You may want to try an HTML control
which works (we have 1 website partly in Chinese  and a content
manager written in Cavo). 

A few years ago Robert demonstrated a nice trick which did allow
reading and writing double byte characters in normal windows on a
Dutch conference. I did receive the code then but I never got it
working fully, but did not spend much time on it. Maybe Robert is
willing to send you that code and you can find the remaining problems?

Finally, I think Vulcan might be your solution. At least it supports
Unicode, what Carlos already wrote you need, and VO doesn't support.

Dick van Kooten

Roger,

I just made an ActiveX in VB6 with 3 controls: EditText, EditTextML, and 
Label. VB6 works with Unicode strings, so maybe this can solve your problem.
I didn't test them, but if you want to try please give me some feedback, 
as it's possible to make a few more controls with unicode support. Just 
register the OCX, generate the VO OLE Classes, and add them to the VO 
Window Editor Palette.

http://www.doossier.com/vo/Unicode.ocx

Hope this help


> I am attempting to display (and eventually enter) simplified chinese 
> characters into a VO (2.8) MLE.  I am using Window Vista Ultimate, SQL 
> Server (2005) as a database and regular VO Datawindows for 
> input/display.  I added a MLE to a window and selected the SimSun font 
> for the MLE.  When I paste the chinese characters into the MLE they 
> display correctly.  However, when I save them to the database (using 
> VO2ADO) they change to ??.  So I tried another tactic and pasted the 
> chinese characters directly into the db column using SQL Server 
> Management Studio.  They are saved just fine in the management studio 
> but when I display them using the VO MLE they display as ??.  Do you 
> have any ideas on how I can accomplish this?
>
> Thanks for any help.
>

-- 
Carlos Rocha

I added Unicode support to a program to be able to display also Chinese 
characters correctly. It is possible to use the Unicode functions for 
RichEdit controls, third party controls like Textcontrol from subsystems and 
make browser enhancements for displaying Unicode. But it was really much 
work which can be avoided starting with Vulcan.

Arne Ortlinghaus
ACS Data Systems


"Roger Lawton" <nsproger@nspsomax.com> schrieb im Newsbeitrag 
news:hoee0m$g12$1@speranza.aioe.org...
>I am attempting to display (and eventually enter) simplified chinese 
>characters into a VO (2.8) MLE.  I am using Window Vista Ultimate, SQL 
>Server (2005) as a database and regular VO Datawindows for input/display. 
>I added a MLE to a window and selected the SimSun font for the MLE.  When I 
>paste the chinese characters into the MLE they display correctly.  However, 
>when I save them to the database (using VO2ADO) they change to ??.  So I 
>tried another tactic and pasted the chinese characters directly into the db 
>column using SQL Server Management Studio.  They are saved just fine in the 
>management studio but when I display them using the VO MLE they display as 
>??.  Do you have any ideas on how I can accomplish this?
>
> Thanks for any help.
>
> -- 
> Roger Lawton
> Product Manager
> SOMAX, Inc. 

Carlos:

I got some pointers from Robert van der Hulst about what VO2Ado does
internally with the code pages (your earlier suggestion about the
AdoVoStr2Unicode) function was right on target.  Anyway, Robert suggested
that I have to change the system locale to chinese and then VO2Ado will use
that code page to translate the data read from the server.  So far this is
working for me.  I can display stored (SQL Server 2005 database) values
using a VO MLE.  Next I will be trying to save chines values.

I tried so many things that I am not currently sure what actually caused it
to work but the following is an attempt at a step by step process:

1) Data storage in SQL Server 2005 as unicode string (Nchar, Nvarchar, etc)
2) Add the Chinese(Simplified) Language in Control Panel / Clock, Language,
and Region / Install/Uninstall display languages
3) Change the system locale (not location) to Chines(Simplified) - Reboot
4) In the VO window use the chinese font (I use the NSimSum but I don't know
if others will work or not)
5) Voila - chinese characters are displayed.

HTH

Roger Lawton
Product Manager
SOMAX, Inc.

"Carlos Rocha" <carlos.deletethis.rocha@doossier.com> wrote in message 
news:CqydnY8RdOIsrjHWnZ2dnUVZ7vqdnZ2d@novis.pt...
> Roger,
>
> I just made an ActiveX in VB6 with 3 controls: EditText, EditTextML, and 
> Label. VB6 works with Unicode strings, so maybe this can solve your 
> problem.
> I didn't test them, but if you want to try please give me some feedback, 
> as it's possible to make a few more controls with unicode support. Just 
> register the OCX, generate the VO OLE Classes, and add them to the VO 
> Window Editor Palette.
>
> http://www.doossier.com/vo/Unicode.ocx
>
> Hope this help
>
>
>> I am attempting to display (and eventually enter) simplified chinese 
>> characters into a VO (2.8) MLE.  I am using Window Vista Ultimate, SQL 
>> Server (2005) as a database and regular VO Datawindows for input/display. 
>> I added a MLE to a window and selected the SimSun font for the MLE.  When 
>> I paste the chinese characters into the MLE they display correctly. 
>> However, when I save them to the database (using VO2ADO) they change to 
>> ??.  So I tried another tactic and pasted the chinese characters directly 
>> into the db column using SQL Server Management Studio.  They are saved 
>> just fine in the management studio but when I display them using the VO 
>> MLE they display as ??.  Do you have any ideas on how I can accomplish 
>> this?
>>
>> Thanks for any help.
>>
>
> -- 
> Carlos Rocha 

It's good to know that's possible without external resources.
The most important thing is to solve the problem, but I still would like 
to know the result with the ocx I posted.


> Carlos:
>
> I got some pointers from Robert van der Hulst about what VO2Ado does
> internally with the code pages (your earlier suggestion about the
> AdoVoStr2Unicode) function was right on target.  Anyway, Robert suggested
> that I have to change the system locale to chinese and then VO2Ado 
> will use
> that code page to translate the data read from the server.  So far 
> this is
> working for me.  I can display stored (SQL Server 2005 database) values
> using a VO MLE.  Next I will be trying to save chines values.
>
> I tried so many things that I am not currently sure what actually 
> caused it
> to work but the following is an attempt at a step by step process:
>
> 1) Data storage in SQL Server 2005 as unicode string (Nchar, Nvarchar, 
> etc)
> 2) Add the Chinese(Simplified) Language in Control Panel / Clock, 
> Language,
> and Region / Install/Uninstall display languages
> 3) Change the system locale (not location) to Chines(Simplified) - Reboot
> 4) In the VO window use the chinese font (I use the NSimSum but I 
> don't know
> if others will work or not)
> 5) Voila - chinese characters are displayed.
>
> HTH
>
> Roger Lawton
> Product Manager
> SOMAX, Inc.
>
> "Carlos Rocha" <carlos.deletethis.rocha@doossier.com> wrote in message 
> news:CqydnY8RdOIsrjHWnZ2dnUVZ7vqdnZ2d@novis.pt...
>> Roger,
>>
>> I just made an ActiveX in VB6 with 3 controls: EditText, EditTextML, 
>> and Label. VB6 works with Unicode strings, so maybe this can solve 
>> your problem.
>> I didn't test them, but if you want to try please give me some 
>> feedback, as it's possible to make a few more controls with unicode 
>> support. Just register the OCX, generate the VO OLE Classes, and add 
>> them to the VO Window Editor Palette.
>>
>> http://www.doossier.com/vo/Unicode.ocx
>>
>> Hope this help
>>
>>
>>> I am attempting to display (and eventually enter) simplified chinese 
>>> characters into a VO (2.8) MLE.  I am using Window Vista Ultimate, 
>>> SQL Server (2005) as a database and regular VO Datawindows for 
>>> input/display. I added a MLE to a window and selected the SimSun 
>>> font for the MLE.  When I paste the chinese characters into the MLE 
>>> they display correctly. However, when I save them to the database 
>>> (using VO2ADO) they change to ??.  So I tried another tactic and 
>>> pasted the chinese characters directly into the db column using SQL 
>>> Server Management Studio.  They are saved just fine in the 
>>> management studio but when I display them using the VO MLE they 
>>> display as ??.  Do you have any ideas on how I can accomplish this?
>>>
>>> Thanks for any help.
>>>
>>
>> -- 
>> Carlos Rocha 
>

-- 
Carlos Rocha

Carlos:

I will check it out when I get a chance.  It will be after next week as I am 
out of the office.

Regards


-- 
Roger Lawton
Product Manager
SOMAX, Inc.

"Carlos Rocha" <carlos.deletethis.rocha@doossier.com> wrote in message 
news:65KdnaIMSYUUSzHWnZ2dnUVZ8iGdnZ2d@novis.pt...
> It's good to know that's possible without external resources.
> The most important thing is to solve the problem, but I still would like 
> to know the result with the ocx I posted.
>
>
>> Carlos:
>>
>> I got some pointers from Robert van der Hulst about what VO2Ado does
>> internally with the code pages (your earlier suggestion about the
>> AdoVoStr2Unicode) function was right on target.  Anyway, Robert suggested
>> that I have to change the system locale to chinese and then VO2Ado will 
>> use
>> that code page to translate the data read from the server.  So far this 
>> is
>> working for me.  I can display stored (SQL Server 2005 database) values
>> using a VO MLE.  Next I will be trying to save chines values.
>>
>> I tried so many things that I am not currently sure what actually caused 
>> it
>> to work but the following is an attempt at a step by step process:
>>
>> 1) Data storage in SQL Server 2005 as unicode string (Nchar, Nvarchar, 
>> etc)
>> 2) Add the Chinese(Simplified) Language in Control Panel / Clock, 
>> Language,
>> and Region / Install/Uninstall display languages
>> 3) Change the system locale (not location) to Chines(Simplified) - Reboot
>> 4) In the VO window use the chinese font (I use the NSimSum but I don't 
>> know
>> if others will work or not)
>> 5) Voila - chinese characters are displayed.
>>
>> HTH
>>
>> Roger Lawton
>> Product Manager
>> SOMAX, Inc.
>>
>> "Carlos Rocha" <carlos.deletethis.rocha@doossier.com> wrote in message 
>> news:CqydnY8RdOIsrjHWnZ2dnUVZ7vqdnZ2d@novis.pt...
>>> Roger,
>>>
>>> I just made an ActiveX in VB6 with 3 controls: EditText, EditTextML, and 
>>> Label. VB6 works with Unicode strings, so maybe this can solve your 
>>> problem.
>>> I didn't test them, but if you want to try please give me some feedback, 
>>> as it's possible to make a few more controls with unicode support. Just 
>>> register the OCX, generate the VO OLE Classes, and add them to the VO 
>>> Window Editor Palette.
>>>
>>> http://www.doossier.com/vo/Unicode.ocx
>>>
>>> Hope this help
>>>
>>>
>>>> I am attempting to display (and eventually enter) simplified chinese 
>>>> characters into a VO (2.8) MLE.  I am using Window Vista Ultimate, SQL 
>>>> Server (2005) as a database and regular VO Datawindows for 
>>>> input/display. I added a MLE to a window and selected the SimSun font 
>>>> for the MLE.  When I paste the chinese characters into the MLE they 
>>>> display correctly. However, when I save them to the database (using 
>>>> VO2ADO) they change to ??.  So I tried another tactic and pasted the 
>>>> chinese characters directly into the db column using SQL Server 
>>>> Management Studio.  They are saved just fine in the management studio 
>>>> but when I display them using the VO MLE they display as ??.  Do you 
>>>> have any ideas on how I can accomplish this?
>>>>
>>>> Thanks for any help.
>>>>
>>>
>>> -- 
>>> Carlos Rocha
>>
>
> -- 
> Carlos Rocha