OpenAccess RTL Support

[Soul]

Hey Guys,

I'm using the OpenAccess Express along with MySQL - and I have a persistent object with an id, first name and last name -
My problem is related to my input being in Arabic.

I changed all the Charsets and Collations on MySQL to UTF8 General - and if I add an entry in English-  everything works fine -
If I add an entry using Arabic - I get all ?????'s in MySQL

Does OpenAccess support Arabic/RTL - and if yes, what am I missing to make it work

Cheers!
Thanks!

[Jan Blessenohl]

Hello Soul,

I have tested the unicode behavior and it is working with some changes to your mapping. The easiest way is to globally change the mapping for string to NVARCHAR. This can be done in the backend configuration settings of your app.config file. You have to have this nodes:

<

 

backendconfiguration id="mysqlConfiguration" backend="mysql">
    <mappingname>mysqlMapping</mappingname>
    <typeMap><typeMapping>
        <ADOType>VARCHAR</ADOType><SQLType>NVARCHAR</SQLType>
    </typeMapping></typeMap>
</backendconfiguration>

The NVARCHAR string is not choosable from the forward mapping dialog, we will change that.

I have attached my sample project that is working with mysql.

Regards,

Jan Blessenohl
the Telerik team

 

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Soul]

Brilliant stuff - will give it a try tonight

Thank you for the prompt and brilliant support ^_^ Loving how accessible and comfortable it is to use OpenAccess [so far]
And a thank you in a more multi-cultural setting
شكرا :-)