Hello!
On Thu, 26 Nov 1998, Dmitry Iv Popov wrote:
> Well, now I have the following problem: base exported from
> VFoxPro (with delimiters '|') contains russian characters
> and command 'copy' produces the error:
>
> // unreadable symbols are russian letters
> rscexamdb=> copy exam with oids from '/opt2/home3/auricvision/db.txt'
> using delimiters '|';
> WARN:pg_atoi: error in "й РПЕЛ НЯМНБМШЛ РХОЮЛ ХМБЕЯРХЖХНММШУ
> ОПНДСЙРНБ ПШМЙЮ ЖЕММШУ АСЛЮЦ НРМНЯЪРЯЪ:": can't parse "й
> РПЕЛ НЯМНБМШЛ РХОЮЛ ХМБЕЯРХЖХНММШУ ОПНДСЙРНБ
> ПШМЙЮ ЖЕММШУ АСЛЮЦ НРМНЯЪРЯЪ:"
> rscexamdb=>
Looks strange. I am using postgres with russian with great success:
COPY positions FROM stdin USING DELIMITERS '|';
1|ЯБХМХМЮ|1|"5 days"|15|1|A
2|ЦНБЪДХМЮ|1|"5 days"|15|2|A
3|ЛНКНЙН|2|"5 days"|15|3|A
4|ЬНЙНКЮД|4|"5 days"|15|4|A
5|ОЕКЭЛЕМХ|1|"5 days"|15|5|A
\.
This work fine, and I have never experienced any problem with "foreign"
letters.
Oleg.
----
Oleg Broytmann National Research Surgery Centre http://sun.med.ru/~phd/
Programmers don't die, they just GOSUB without RETURN.