OpenAccess RTL Support

Thread is closed for posting
3 posts, 0 answers
  1. Soul
    Soul avatar
    5 posts
    Member since:
    Apr 2009

    Posted 19 Apr 2009 Link to this post

    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!
  2. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 22 Apr 2009 Link to this post

    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.
  3. Soul
    Soul avatar
    5 posts
    Member since:
    Apr 2009

    Posted 22 Apr 2009 Link to this post

    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
    شكرا :-)

Back to Top