Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mike castillo
  Where is mike castillo?
 Joo Seng Road, Singapore
 Philippines
 mike castillo
 To: Yousfi Benameur
  Where is Yousfi Benameur?
 El Bayadh
 Algeria
 Yousfi Benameur
 Tags
Subject: RE: VFP Unicode
Thread ID: 209249 Message ID: 209301 # Views: 118 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Saturday, December 27, 2008 2:26:19 AM         
   


> > Hi Guys,
> >
> > I need your input on this, I have already achieved to display Unicodes on Form (Save & Retrieve). But how about the report FRX, any advice is greatly appreciated.
> >
> >
> >
> >
> > Thanks.
> >
> > Kind regards,
> > Mike
>
> Hi Mike
> i dont know if you see this thread on unicode Message ID: 208914
>
> i used a windows form textbox (activeX) who is unicode and can load any language.it works with many languages at same time.I try to write with arabic and french in the same textbox and it works with two.
>
> The component you use is also an activeX (flex grid).
>
> I dont see a vfp issue for building/previewing/printing a report with many languages.Its possible for one language installed with many prerequies(RTL configuration for Arabic...)
>
> Vfp is not unicode and then dont accept these characters together.
> VFP report can accept fields images (as oleboundcontrol).
>
> There is one solution by west wind: showing all these data in html and then can
> preview/print like a report.
>
> that is made passing by binary unicode data(blob fields),unicode data (easy for html).
> this is a west wind code for an example of that i adapted :
>
>
> clea all
> IF !FILE("ForeignData.dbf")
>    *** Create table with binary text fields!
>    CREATE TABLE FOREIGNDATA  ( ID C(10),DESCRIPT  Blob,LDESCRIPT Blob)
>    USE ForeignData Shared           
>  
>    *** Load up sample data as binary Unicode!    
>    INSERT INTO  ForeignData ;
>    ( id,descript,lDescript) VALUES;
>    ( SYS(2015), STRCONV("Korean",5),;
>      STRCONV("IAAgACAAIADIwG24jKwgAIzBHKwYtJSyIABLusTJIADostC5MK4gAHzOfLcgAA==",14))
>  
>    INSERT INTO  ForeignData ;
>    ( id,descript,lDescript) VALUES;
>    ( SYS(2015),STRCONV( "Chinese",5) ,;
>      STRCONV("rpt3gmlfcoJnUW5/b5g6eU9c",14)  )
>   
>    INSERT INTO  ForeignData ;
>    ( id,descript,lDescript) VALUES;
>    ( SYS(2015),STRCONV( "Russian",5),;
>      STRCONV("EQQ+BDsETARIBD4EOQQgAEYEMgQ1BEIEPQQ+BDkEIAAyBD0EQwRCBEAENQQ9BD0EOAQ5BCAANAQ4BEEEPwQ7BDUEOQQ=",14)  )
> ELSE
>   USE ForeignData IN 0
> ENDIF           
> SELECT ForeignData
> * brow
> 
> export  to c:\asup.xls  xl5
> select Id,Descript as Note,LDescript as Description   FROM ForeignData INTO CURSOR TFData 
> SELECT Id, CAST(STRCONV(Note,10) as M)  as Note , CAST(STRCONV(Description,10) as M) as Description;
>  FROM TFData  INTO CURSOR TFData2
> * brow  
> 
> TEXT TO lcHTML
> 
> 
> 
> VFP Unicode Data Representation
> 
> ENDTEXT
> *** UTF-8 Encode - not necessary here, but if you had extended text
> *** you'd need to do this
> lcHtml = STRCONV(lcHTML,9)
>  
> SCAN
>    lcHTML = lcHTML + Note + " - " + Description + ;
>             "" + CHR(13) + CHR(10)
> ENDSCAN
> lcHTML = lcHTML + ""
> *****************************************
> afile="c:\asup.html"
> set textmerge on to (afile) noshow
> \<<lchtml>>
> set textmerge to
> 
> apIE=createObject('internetexplorer.application')
> apIe.navigate(afile)
> do while apIE.busy or apie.readystate#4
> enddo
> with apIE
> .visible=.t.
> .width=sysmetric(1)
> .height=sysmetric(2)
> .top=0
> left=0
> endwith
> ********************************************************
> 

>
> Then you can see all languages input appear in the page at the same time.
> You have a page web ,you can preview and print easily.
> Regards

Hi Yousfi,

Thank you for your codes, I will check on it and give some updates later.

Kind regards,
Mike

ENTIRE THREAD

VFP Unicode Posted by mike castillo @ 12/26/2008 11:17:26 AM
RE: VFP Unicode Posted by Koen Piller @ 12/26/2008 11:48:29 AM
RE: VFP Unicode Posted by mike castillo @ 12/26/2008 1:41:50 PM
RE: VFP Unicode Posted by Yousfi Benameur @ 12/26/2008 11:30:21 PM
RE: VFP Unicode Posted by mike castillo @ 12/27/2008 2:26:19 AM
RE: VFP Unicode Posted by Erik Gomez @ 12/27/2008 1:58:44 AM
RE: VFP Unicode Posted by mike castillo @ 12/27/2008 2:28:21 AM
RE: VFP Unicode Posted by Samir Ibrahim @ 12/27/2008 6:27:29 PM
RE: VFP Unicode Posted by mike castillo @ 12/28/2008 1:57:54 AM
RE: VFP Unicode Posted by Yousfi Benameur @ 12/28/2008 1:25:12 AM
RE: VFP Unicode Posted by mike castillo @ 12/28/2008 1:59:26 AM
RE: VFP Unicode Posted by mike castillo @ 12/29/2008 7:39:25 AM
RE: VFP Unicode Posted by Yousfi Benameur @ 12/30/2008 2:29:16 PM
RE: VFP Unicode Posted by mike castillo @ 12/30/2008 3:26:13 PM
RE: VFP Unicode Posted by khubaib khalid @ 4/26/2009 7:23:55 PM
RE: VFP Unicode Posted by Bernard Bout @ 7/3/2009 1:39:42 AM
RE: VFP Unicode Posted by mike castillo @ 7/3/2009 5:27:49 AM
RE: VFP Unicode Posted by Aziz Ahmad @ 2/3/2014 12:18:17 PM
RE: VFP Unicode Posted by Sio Ieng cheng @ 6/1/2017 11:34:37 AM
RE: VFP Unicode Posted by Eric de Haan @ 7/2/2009 1:07:36 PM
RE: VFP Unicode Posted by mike castillo @ 7/2/2009 5:34:18 PM
RE: VFP Unicode Posted by Eric de Haan @ 7/3/2009 9:49:20 AM
RE: VFP Unicode Posted by mike castillo @ 7/3/2009 10:10:25 AM
RE: VFP Unicode Posted by Eric de Haan @ 7/3/2009 10:24:47 AM
RE: VFP Unicode Posted by Yousfi Benameur @ 7/3/2009 2:20:20 AM
RE: VFP Unicode Posted by Eric de Haan @ 7/4/2009 10:08:04 AM
RE: VFP Unicode Posted by khubaib khalid @ 7/6/2009 1:28:41 PM
RE: VFP Unicode Posted by Yousfi Benameur @ 7/6/2009 5:46:14 PM
RE: VFP Unicode Posted by khubaib khalid @ 7/7/2009 3:39:52 PM
RE: VFP Unicode Posted by Yousfi Benameur @ 7/7/2009 4:22:24 PM
RE: VFP Unicode Posted by Yousfi Benameur @ 7/7/2009 7:46:04 PM
RE: VFP Unicode Posted by khubaib khalid @ 7/8/2009 11:13:57 AM
RE: VFP Unicode Posted by Yousfi Benameur @ 7/8/2009 3:21:36 PM
RE: VFP Unicode Posted by mike castillo @ 7/3/2009 4:07:55 AM
RE: VFP Unicode Posted by Bernard Bout @ 7/3/2009 5:08:33 AM
RE: VFP Unicode Posted by mike castillo @ 7/3/2009 5:45:27 AM
RE: VFP Unicode Posted by Bernard Bout @ 7/3/2009 11:25:18 AM
RE: VFP Unicode Posted by Yousfi Benameur @ 7/3/2009 11:01:23 AM
RE: VFP Unicode Posted by Bernard Bout @ 7/3/2009 2:43:46 PM
RE: VFP Unicode Posted by khubaib khalid @ 7/8/2009 6:17:33 PM
RE: VFP Unicode Posted by Christof Wollenhaupt @ 7/6/2009 1:43:48 PM
RE: VFP Unicode Posted by Cesar @ 7/7/2009 12:24:04 AM
RE: VFP Unicode Posted by Sam @ 12/18/2009 4:40:15 AM
RE: VFP Unicode Posted by Hoe Theam Nee @ 4/2/2011 6:38:11 AM
RE: VFP Unicode Posted by khubaib khalid @ 4/3/2011 4:50:11 PM
RE: VFP Unicode Posted by Hoe Theam Nee @ 4/3/2011 8:53:14 PM
RE: VFP Unicode Posted by khubaib khalid @ 4/5/2011 4:28:33 PM
RE: VFP Unicode Posted by mike castillo @ 1/16/2013 6:42:52 AM
RE: VFP Unicode Posted by Sam @ 1/17/2013 8:36:20 AM
RE: VFP Unicode Posted by Sam @ 1/15/2013 2:23:44 AM
RE: VFP Unicode Posted by Cesar @ 2/3/2014 2:54:49 PM
RE: VFP Unicode Posted by Tore Bleken @ 2/3/2014 2:59:53 PM
RE: VFP Unicode Posted by Cesar @ 2/3/2014 3:01:52 PM
RE: VFP Unicode Posted by Tore Bleken @ 2/3/2014 3:05:45 PM
RE: VFP Unicode Posted by Koen Piller @ 2/3/2014 5:35:42 PM
RE: VFP Unicode Posted by Aziz Ahmad @ 2/4/2014 7:31:51 AM
RE: VFP Unicode Posted by Cesar @ 2/4/2014 1:01:46 PM
RE: VFP Unicode Posted by Trial Trial @ 4/3/2016 7:12:46 AM
RE: VFP Unicode Posted by Tore Bleken @ 4/3/2016 11:06:30 AM
RE: VFP Unicode Posted by Glen Villar @ 4/5/2016 12:34:21 AM