Hi list
Im new to the list so i hope it's the right place for my post.
For a projekt i am combining different tables. Everything seems to work,
but in some rows the "Kode" field VARCHAR(10) ends up as INT. I will try
to explain with an example.
Table1
46
47
48
67
Table2
BBEGYNDER
BVILDIVAND
01ELITE
02SSKOLEN
When i combine these i get
46
47
48
67
0
0
01
02
The desired result should be:
46
47
48
67
BBEGYNDER
BVILDIVAND
01ELITE
02SSKOLEN
== MySQL statements to create the combined table ==
===================================================
DROP TABLE IF EXISTS searchTemp;
CREATE TABLE searchTemp (
`table` VARCHAR( 25 ) NOT NULL ,
`id` VARCHAR ( 10 ) NOT NULL ,
`headline` TEXT NOT NULL ,
`teaser` TEXT NOT NULL ,
`text` TEXT NOT NULL ,
`image_id` INT NOT NULL
);
ALTER TABLE
`searchTemp`
ADD FULLTEXT
(
`headline` ,
`teaser` ,
`text`
);
INSERT INTO searchTemp
(
SELECT 'content', id, headline, text, teaser, image_id FROM content
)
UNION ALL
(
SELECT 'wesHoldKategori', wesHoldKategori.Kode AS id, Navn AS headline,
Beskrivelse AS text, '', image_id FROM wesHoldKategori
);
===================================================
Anyone who can explain why this is happening and how i can solve it?
Thanks in advance
Dennis Duggen
--
Airconditioners and computers have one thing in common:
Once you open windows everything fails.
--
Firefox - Safer, Faster, Better
http://www.mozilla.org/products/firefox/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
