From: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Encoding problem |
Date: | 2006-10-23 12:41:48 |
Message-ID: | 453CB88C.2030106@freesurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi List !
I am trying to remove accents from a string. I found a nice
solution for this on postgresqlfr, using the to_ascii()
function.
Now, the problem I have is :
mydb=# SELECT to_ascii(convert('abcdef', 'LATIN9'));
ERROR: encoding conversion from UTF8 to ASCII not supported
Why is the conversion to LATIN9 not working as expected ?
My database's encoding is UTF8.
Furthermore, in PgAdmin, running SELECT convert(somestring,
'LATIN9'); returns empty strings whenever somestring
contains special (accentued, in my case) characters.
SELECT Length(convert(somestring, 'LATIN9')); looks OK though !
I think my misunderstanding of encoding is driving me crazy...
Could anyone help me on this ?
Thanks !
--
Arnaud
From | Date | Subject | |
---|---|---|---|
Next Message | Wes Sheldahl | 2006-10-23 13:39:19 | Re: unstable postgres on freebsd |
Previous Message | Hugo | 2006-10-23 12:24:59 | Fwd: how to check SQLSTATE |