Home

Tips
  Umlauts/UTF-8
  Normalization
  OemToAnsi
  MySQL Import
  Site Search
  City Desk
  DynDNS
  MXLookup
  SPAM

SDT

Support
  Downloads
  Contact Us

Impressum

German

Web Search

English Version

What's up here ? By Antje Binas-Holz Last Update: Sunday, October 02, 2005 MySQL is the world's most popular Open Source Database. MySQL Home Page:   http://www.mysql.com . WebSeller Online Shop is an Open Source based CGI Application for creating professional MySQL based shop solutions. Visit   http://www.nwu.de for more information. You reached a web site primarily dedicated to MySQL based web development and tools. As former contributor for SDT and other magazines I would like to continue to share my experiences using this site. Together with my husband, Uwe Holz, we are more or less regular publishing appropriate articles in English and German.  German umlauts and UTF-8 12/29/05 We have been asked recently in our Forum about  German Umlauts based on UTF-8 . It turned out to be a problem being worth a more deeper discussion. The problem itself came up while working with CityDesk used as Content Manager. Everything looked ok, CityDesk templates have been configured correctly, however all characters above code 127  have not been displayed correctly in the browser. What went wrong? MySQL Data Import 02/16/06 Do you know the problem? You are about to migrate an existing project to MySQL while looking for an appropriate conversion tool. Utility ImpSql can be the solution for this problem. It supports DBF and CSV file import as well as all usual memo file formats like FPT (FoxPro, Comix), DBT (Clipper) and DBV (FlexFile) . MySQL Import and Normalization 01/10/04 Lots of articles and books describe data normalization and information given there often scare people instead of offering some help. I am not going to dive into another theoretical discussion about different normalization forms and how to achieve them.  This article is trying to solve a real world problem people are often faced with instead:  How can I import a single Excel like spreadsheet into one or more MySQL tables representing the first normal database form? From Oem to Ansi 12/28/03 Data conversion from old DOS based projects often requires Oem2Ansi translation. You might say that this is not a big deal, since Windows has build in all required functions to do the job. Well, that's true but what if you are developing a platform independent tool, you have to support different language settings or you need a way to support a language where you don't even know the rules for this conversion? The following article desribes a generic way to solve all these problems by a template based Oem to Ansi translation. Site Search 10/19/03 A local search facility is a very important property of well designed web sites. There is a couple of tools available in order to implement a site based search. On the other hand big search engines like Google offer the option to index the site in order to use it's own engine. The drawback are monthly index updates made by Google. Changes (document updates, deletions or additions) will be disregarded by user search requests until the next index update have been made. The following article describes a WebSeller based site search approach not depending on any other third party service ... A full featured Web Site Template made with CityDesk 09/14/03 To set up a full featured Web Site including shopping area, discussion board and search capabilities can be a demanding challenge especially if you have to combine it with an easy to use Content Management System. But I am pretty sure that I finally found exactly what I need and ended up with following solution. How to fight SPAM 07/07/03 SPAM is the usual expression for unsolicited e-mails. The term stands for Spiced Ham or SPread Around Message. Other sources are stating that the origin of the word SPAM comes from a Monthy Python Sketch. Forumware 08/04/03 A discussion board for exchanging opinion and know how is a key feature of good and supportive web sites. When I thought about how to implement it I end up with the idea of using WebSeller. And guess what, it works! No limitation, no runtime fees. The license free version of WebSeller does the job perfectly. The following article describes the solution. DynDNS - My own Internet domain 11/03/05 Do you want to host your own web site by yourself using your DSL connection to the Internet? You don't want to depend on an external ISP anymore? Do you want to have this all for free? This article shows you how it works ... MXLookup - How to start system tools 06/30/03 MXLookup can be used in order to determine the e-mail relay servers for a specific e-mail domain name. This approach is described by RFC 2821 for Internet mail transport from client to server and between different mail server. See how to use it within your application.

Antje works as a Software Developer for many years. All contents Copyright 2003-2004 by Antje Binas-Holz, Software Development. All Rights Reserved.