Re: [ADMIN] COPY doesn't works when containing ' ' or ' ' characters on db

2001-02-27 Thread Oliver Elphick
Tom Lane wrote: Jaume Teixi [EMAIL PROTECTED] writes: I finally percated that when data contains '' or '' it's impossible to parse trought: COPY products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g it causes: SELECT edicion FROM products; edicion

Re: [ADMIN] COPY doesn't works when containing ' ' or ' ' characters on db

2001-02-27 Thread Tom Lane
"Oliver Elphick" [EMAIL PROTECTED] writes: I think this happens when the front-end encoding is SQL_ASCII and the database is using UNICODE. Then, there are misunderstandings between front-end and back-end, so that a single character with the eighth bit set may be sent by the front-end and

Re: [HACKERS] Re: [ADMIN] COPY doesn't works when containing ' 'or ' ' characters on db

2001-02-27 Thread Tatsuo Ishii
"Oliver Elphick" [EMAIL PROTECTED] writes: I think this happens when the front-end encoding is SQL_ASCII and the database is using UNICODE. Then, there are misunderstandings between front-end and back-end, so that a single character with the eighth bit set may be sent by the front-end