From: | ªZÀs <wuulong(at)penpower(dot)com(dot)tw> |
---|---|
To: | postgres <pgsql-general(at)postgresql(dot)org> |
Subject: | SQL command Question : Copy from File |
Date: | 1999-12-29 02:38:40 |
Message-ID: | 38697430.B3C5F24E@penpower.com.tw |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)penpower(dot)com(dot)tw (O)035722691-362 (M)0923135231 (icq)11934112
From | Date | Subject | |
---|---|---|---|
Next Message | Courtney Thomas | 1999-12-29 03:26:00 | Re: [GENERAL] Admin / client tools for Win32? |
Previous Message | Howie | 1999-12-28 21:46:46 | Re: [GENERAL] Admin / client tools for Win32? |