Alpha Video Training
Results 1 to 3 of 3

Thread: MySQL by desktop applications

  1. #1
    Member Corelius's Avatar
    Real Name
    Cornelius Koempel
    Join Date
    May 2005
    Germany, Duisburg

    Default MySQL by desktop applications

    We are going to convert our dbf tables to MySQL very successfully in the last months. Final test with our desktop applications are almost finished. Later on, we want to use the Alpha Five application server.

    We had many problems with the German characters, äöüß. But we could solve the problems, when we change the collation to latin1_german2_ci. Then we import the data from dbt to mysql. The sort result is better than within dbf databases. The program MySQL Workbench has been very helpfully.

    When we start the query by form, we can’t find word that contains German character. Instead of the special characters we use placeholder *, just a workaround.

    Today I used query by genie and I have been amazed that we can found any words.

    May be it is a bug? Any suggestions?


  2. #2
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004

    Default Re: MySQL by desktop applications

    Why not query using chr() instead of the "placeholders".
    for example, for ä search using chr(-28)

  3. #3
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    In the Wolds, Louth, Lincolnshire, UK

    Default Re: MySQL by desktop applications

    You should be able to insert the Alternate character set using alt + char number.

    Example holding down alt and keying 171 returns a "½".
    Bit clunky though.
    Ted Giles
    Example Consulting - UK
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. Same controls for browser and desktop applications
    By rmcgaffic in forum Archived Wishlist
    Replies: 0
    Last Post: 09-02-2010, 06:57 AM
  2. Is there a future for desktop applications.
    By Marcel Kollenaar in forum Application Server Version 9 - Web/Browser Applications
    Replies: 51
    Last Post: 07-14-2009, 03:47 PM
  3. A5 Desktop-Web-Applications: possibly a new model
    By neil_albala in forum Alpha Five Version 8
    Replies: 8
    Last Post: 03-30-2007, 04:21 PM
  4. On the LAN: desktop vs web applications
    By jmatienza in forum Web Application Server v7
    Replies: 16
    Last Post: 05-30-2006, 12:51 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts