Re: Displaying string including Kanji characters

[dan orlic]

INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as category_id, 
'' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1 + g.Desc2 + 
g.Desc3 as description, g.Desc4 as price,0 as quantity, '' as 
comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type, now() 
as created, now() as last_modified FROM copperlamp.Items g order by 
g.RecordID asc;

and it does not error out, but there are problems with this... for example:
... g.Desc4 as price ... g.Desc4 ($500.00) is a varchar and price is a 
BigDecimal(10.2). but when it gets inserted  the value is 0.00 for every 
field.... that's one the other is:
...g.Item + g.Desc1 + g.Desc2 + g.Desc3 as description ... but though 
they are all varchars i can't seem to incorporate all the values into 
that one field.  any thoughts would be great.

dan

--

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]