Does Copy from file Support Chinese ?
I have a file and data like this : ( second row is chinese )
1234,·s¦Ë¥«
5678,¥x¥_¥«
my table "phrase" schema is ( id int4 , phrase char(30))
my SQL command is
Copy phrase from 'filename' using delimiter ',';
return message is Copy.
and result in data is have same row insert but all empty include first
int4 column ?
my postgresql version is 6.4
Have idea about this question , Please let me know thanks.
--
wuulong Sheu ( ³\ªZÀs ) - PGP , HTML mail is welcome
»X«ï¬ì§Þ - PEN POWER TECHNOLOGY LTD.(www.penpower.com.tw)
wuulong@penpower.com.tw (O)035722691-362 (M)0923135231 (icq)11934112