Re: Displaying string including Kanji characters

2004-04-08 Thread 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

Re: Displaying string including Kanji characters

2004-04-08 Thread Hirofumi Fujiwara
> When I use multi-byte code (especially UTF-8) with data including > Kanji (Japanese kanji character) and execute SELECT from mysql > client command, the vertical lines(|) of output table aren't aligned > as straight lines and the output doesn't look like a table. > > When I use SJIS code, the