RE: strange ws_concat,concat result

"Nyström, Rasmus" writes: > I tried it now. > > Not on the 2000 Server, but on my NT4 SP6 > > The problem still occures, let's me describe the tests. > > The table looks like this: > id| int(10) unsigned | | PRI | NULL| auto_increment > title | varchar(255) | Y

RE: strange ws_concat,concat result

> "Nyström, Rasmus" writes: > > How come the query > > > > SELECT > > > CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc > ,created,modif > > ied,bugstatus,submitter), '"') FROM tbl_bug; > > > > returns something like > > "4","4","4" > > "10","10","10" > > > > while on

Re: strange ws_concat,concat result

"Nyström, Rasmus" writes: > How come the query > > SELECT > CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif > ied,bugstatus,submitter), '"') FROM tbl_bug; > > returns something like > "4","4","4" > "10","10","10" > > while only > > SELECT > CONCAT_WS(

strange ws_concat,concat result

How come the query SELECT CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif ied,bugstatus,submitter), '"') FROM tbl_bug; returns something like "4","4","4" "10","10","10" while only SELECT CONCAT_WS(';',title,prio,category,program,bugdesc,created,modified,bugstatus ,