Re: [SPAM]-D] [SQL] How to find broken UTF-8 characters ?

On 04/26/10 04:12, Andreas wrote: Excel files > pgAdmin > Access. looks like a complete offtopic How can I find those broken UTF-8 characters? How can I get rid of them? iconv -c BUT u should not have those characters at all if one is occured it most probably an error AND u should get ri

Re: [SPAM]-D] [SQL] How to find broken UTF-8 characters ?

Am 26.04.2010 12:12, schrieb silly sad: On 04/26/10 04:12, Andreas wrote: looks like a complete offtopic Not anymore. The bad signs are in the DB now. I'd need some command that filters somehow for inconvertible (Unicode-->local charset) data. How can I find those Unicode characters that all

Re: [SPAM]-D] Re: [SPAM]-D] [SQL] How to find broken UTF-8 characters ?

How can I get rid of them? iconv -c AFAIK iconv would translate on file system level but I would think that messed up a allready messed up Excel workmap even further. I'd be glad to handle csv, too. pg_dump | iconv -c | psql -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To mak

Re: [SQL] count function alternative in postgres

Thanks tkellerer. Junaid tkellerer wrote: > > junaidmalik14 wrote on 03.04.2010 14:58: >> >> Is there any alternative of mysql function COUNT(DISTINCT expr,[expr...]) >> in >> postgres. We get error if we >> >> write count like this count(distinct profile.id, profile.name, >> profile.age) >> but

Re: [SQL] count function alternative in postgres

Thanks Ben. It works fine. Junaid. Ben Morrow-2 wrote: > > Quoth junaidmali...@gmail.com (junaidmalik14): >> >> Is there any alternative of mysql function COUNT(DISTINCT expr,[expr...]) >> in >> postgres. We get error if we >> >> write count like this count(distinct profile.id, profile.name