As you know full-text search means searching words on database. So how we understand (or find) a string is a word or not?

We have only one option to understand words. That’s the white spaces after words.

This can be a common problem if you save words on a column like these :

Read the rest of this entry »

When using Zeos Database Objects you can encounter some problems about charset. The main charset problem will be that you’re using a charset different than latin1. In this case you can get some errors while showing or fetching data from mySQL.

We have a simple solution :

Read the rest of this entry »

If you are using any OLE dedicated object (for example, if you’re parsing an xml document, there was a XMLDocument in your program, etc) and also if you’re using thread at the same time you can get some errors, mostly cache, ram errors. To solve this situation you must write;

CoInitialize(nil);

at your thread code before execute method. And after the thread function ends you must write;

CoUnInitialize;

Sometimes working with sessions can be hard. But in fact all of those hardness comes from an unproper php.ini setup.

In this entry i’ll discuss about common session problems and of course the solutions.

Read the rest of this entry »

You’ve backuped your database using mysqldump utility. Want to transfer your old database schema to your new database on a new server. But when you try to insert your schema you got an error like this :

#1044 - Access denied for user: 'your_user_name@localhost' to database 'your_database'

Why this error occured?

Read the rest of this entry »

Sometimes you can encounter errors like below while starting your Delphi IDE :

Unable to open key "SOFTWARE\\Borland\\BDS\\3.0\\Personalities" for read
or
Unable to open key "SOFTWARE\\Borland\\BDS\\4.0\\Personalities" for read

This error can occur by any of these :

Read the rest of this entry »