--- proc.sql	2013-04-17 15:25:04.749626723 +0200
+++ proc4.sql	2013-04-17 15:27:05.024628901 +0200
@@ -512,7 +512,13 @@
       -- create the temporary table word2Phoneme from the split result
      drop temporary table if exists word2Phoneme;
 
-     create temporary table word2Phoneme as 
+     create temporary table word2Phoneme
+     (
+       `word` VARCHAR(100)  CHARSET 'utf8' not null,
+       `phoneme` VARCHAR(100)  CHARSET 'utf8' not null
+     ) engine = memory;
+
+     INSERT INTO word2Phoneme
      select T.word, T.phoneme from  (select v as word, SUBSTRING_INDEX(doublemetaphone(left(v,37)), ';',-1) as phoneme
                                              from tmpSplitValues
                                              where length(v) > 2