Thanks a lot
Lots like nice a easy solution.. I am not sure if this is fast solution..
Many convertions you know.. :-(
Thanks a lot anyway.
John
On Wed, 12 Dec 2007 17:13:01 +0100, Pavel Stehule
<[EMAIL PROTECTED]> wrote:
Hello
It's look like SQL_ASCII support diacritic chars now. Fi
On 12/12/2007, Jan Sunavec <[EMAIL PROTECTED]> wrote:
> Thanks a lot
>
> Lots like nice a easy solution.. I am not sure if this is fast solution..
> Many convertions you know.. :-(
> Thanks a lot anyway.
>
If you do this often, use functional index.
Pavel
>John
>
> On Wed, 12 Dec 2007 17:13:
Hello
It's look like SQL_ASCII support diacritic chars now. First you have
to encode from bytea to text
postgres=# SELECT encode(convert('ján', 'UNICODE', 'SQL_ASCII'),'escape');
encode
ján
(1 row)
you wont
postgres=# SELECT to_ascii(encode(convert_to('ján',
'latin2'),'escape'),'latin
Hi all
I have problem with "convert" function. Previous behaviour was
SELECT convert('ján', 'UNICODE', 'SQL_ASCII');
===
jan
In postgresql 8.3 is quite new behaviour.
SELECT convert('ján', 'UNICODE', 'SQL_ASCII');
==
"j\241n
