Multiple Language / Unicode Support in V11

[aal_fareed]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

I like it!

thx mr. peter :)

[Steve Wood]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

Results are so-so. It appears in the grid fine, but is of course left-to-right editing. It does appear in the grid properly in working preview and sent to a browser. It does not render properly in a Report, etc. I don't know enough about unicode to know if I am doing all of these correctly. Half of the books in my house are in Farsi, so I should get more familiar.

I did test it on CKEditor (the HTML editor that I use) and it works perfectly including the right-to-left typing. Here is an example of that (set the language to Arabic): http://nightly.ckeditor.com/7366/_sa...languages.html

alpha1.gif

[aal_fareed]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

Results are so-so. It appears in the grid fine, but is of course left-to-right editing. It does appear in the grid properly in working preview and sent to a browser. It does not render properly in a Report, etc. I don't know enough about unicode to know if I am doing all of these correctly. Half of the books in my house are in Farsi, so I should get more familiar.

I did test it on CKEditor (the HTML editor that I use) and it works perfectly including the right-to-left typing. Here is an example of that (set the language to Arabic): http://nightly.ckeditor.com/7366/_sa...languages.html

[ATTACH=CONFIG]31196[/ATTACH]

i can see the Arabic letter working fine and i can read it ...
is that mysql ? can we make it into DBF ? i really appreciate your work ...
dude for me i think u r one of the best helpfull people i ever met in my life ... the world need more of you ... thanks alot .. but can you confirm if we can get this into DBF ?
about the right - left sides ... i think we can control it from the field property by inserting html tag ...
hmmmm ...
kamel ? did i suggest you to use mysql today...
Anyways i still want to know if we can use the DBF for that arabic letters
Thanks alot for your cob ration

[Selwyn Rabins]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

there is no support for unicode in .dbf tables - you have to use a sql backend.

in a web application, i can't think of any reason to favor .dbf tables over a sql backend.

[Steve Wood]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

Ahmed,

I did not get around to testing in in DBF, but I am sure Selwyn is right. It is very obvious as you read online about unicode and database that the database itself has to support this. In creating my SQL tables I had to specifically toggle the table to accept unicode.

Unless you have to write serious code, there is hardly any difference between DBF and SQL when it comes to using Alpha Five. If you do have to write code, it is very different - but there are billions of references on the web to assist.

[aal_fareed]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

there is no support for unicode in .dbf tables - you have to use a sql backend.

in a web application, i can't think of any reason to favor .dbf tables over a sql backend.

and this is what the thread about , am asking if its possible for alpha to throw the problem in the thread so all developers can share knolwlge as they might one day solve this issue ,
as well ,
in V10 we could display the arabic or other languages , but not in v11 as shown in kamel post and attachments ,

can you tell me why this is happening ?


and btw i just tried mysql now and its not working .. something fishy is going on ,
mr steve i think u were using v10 ... this is ok it will work in dbf as well ..
but the problem exists in V11
and 5 minits i will submit a bug report with test case etc ...

[aal_fareed]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

, i can't think of any reason to favor .dbf tables over a sql backend.

i can tell you many reasons ,
first of all we will lose very important functions such as oprations in the tables ,
oprations cannot connect to sql back end ,
and we will not have the full functional properties in sql as we got in the DBF ,
i.e join table , crosstab table , appending , i am talking about geniun buttons , also i am not sure about that , but we might lose some functional properties like look up as i tried it befor in v10 ,
i dont know whats going on now , you guys telling me something , and i see something else !!!
i agree there is no diffrence as a database , but as features , and functions that alpha provide in dbf ,
yes we are going to lose that
so yes its big deal for me .
please do not ignoore these points or correct me if i am mistaken , i know you guys are busy and hard working ,
but i still want answers cus i am in middle of projects and i am assuming that alpha developers should help me to sort any issue that am facing .
waiting for answers still .
Regards
Ahmed Sh

[Tom Cone Jr]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

Ahmed, Alpha Five's dbf format is the same as Foxpro 2.6. As Selwyn said this format does not support unicode characters.

If you have an example in v10 where you store arabic characters in a DBF table I'd like to see it. Could you post it here as an attachment to your next reply?

[aal_fareed]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

Ahmed, Alpha Five's dbf format is the same as Foxpro 2.6. As Selwyn said this format does not support unicode characters.

If you have an example in v10 where you store arabic characters in a DBF table I'd like to see it. Could you post it here as an attachment to your next reply?

hey tom ,
the above attachment in kamel post is same issue ,

and here is another attachment of version 10 displaying the Arabic characters correctly without any problem .. so why this issue is existing in v11 ?
i think mr steve have tested the mysql and inserted Arabic char in V10 .. not in V11 .. and if it was V11 why this is happening to me .
1234.jpg

i have submitted bug report just now to alpha and waiting for replay ,

[aal_fareed]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

there is no support for unicode in .dbf tables - you have to use a sql backend.

in a web application, i can't think of any reason to favor .dbf tables over a sql backend.

i have sent you CC about the bug report .. can you confirm that you received it ?
Regards
waiting for answers

[Tom Cone Jr]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

Ahmed,

Thanks for the screen shot. Where is the data stored that is being displayed here?

I'm trying to understand what you are saying.

1) Do you have an example where you stored arabic characters in a native Alpha Five (DBF) table? If not, is this what you are criticizing?

OR

2) Are you saying, instead, that arabic characters stored in an SQL database that supports Unicode fields can no longer display that data in v11 of Alpha Five?

-- tom

[Steve Wood]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

mr steve i think u were using v10 ..

I was using V11, MySQL set to Unicode and a normal V11 Grid.

[Kamel]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

Dear Mr. Steve

I'm using V11 and the problem appear, and here is screen shoot from V11 Live Preview, Web Browser and MySQL Workbench.
Please Note the problem by this Photos:

Alpha5Bug1.jpg Alpha5Bug2.jpg Alpha5Bug3.jpg

Regards

[Selwyn Rabins]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

hey tom ,
the above attachment in kamel post is same issue ,

and here is another attachment of version 10 displaying the Arabic characters correctly without any problem .. so why this issue is existing in v11 ?
i think mr steve have tested the mysql and inserted Arabic char in V10 .. not in V11 .. and if it was V11 why this is happening to me .
[ATTACH=CONFIG]31207[/ATTACH]




i have submitted bug report just now to alpha and waiting for replay ,

actually, you submitted a PICTURE of a bug - you did not submit a test case, or instructions on how to repeat the bug. there are instruction on how to submit a bug report when you select help/submit a bug report.

[aal_fareed]

Re: Weakness of Alpha software V11 ( PLEASE READ ALL ) IMPORTANT

Ahmed,

Thanks for the screen shot. Where is the data stored that is being displayed here?

I'm trying to understand what you are saying.

1) Do you have an example where you stored arabic characters in a native Alpha Five (DBF) table? If not, is this what you are criticizing?

OR

2) Are you saying, instead, that arabic characters stored in an SQL database that supports Unicode fields can no longer display that data in v11 of Alpha Five?

-- tom

OK i will try to simplify the problem in very shorts words .
simply , i used to save arabic characters in dbf table . when i click on this dbf table .. i cannot read it properly due to the unicode problem
but when i display this saved data through a grid .. it will work fine without any issues . this is how i used to work in V10

but now in V11 when i save arabic charcters in dbf table . i cant display it at all from grids
why this is happening to me ?
yes and i do have examples . pls add me in my email i will give you access to one of the systems that i created in V10 and the arabic characters are being displayed correctlu

and please forget about the SQL . this has nothing to do with SQL am now talking about DBF .
Regards
my email
[email protected]