How to avoid error with convert() function
SELECT convert(myfield,'LATIN2','WIN1250') FROM tbl;
ERROR: character 0x828e of encoding "MULE_INTERNAL" has no equivalent in
"WIN1250"
I know I have few characters like this one in table with about 1.000.000
rows.
How to avoid such error and show eg. ? instead of error , or how to replace
such characters with some normal chars ?
tnx
zeljko wrote:
SELECT convert(myfield,'LATIN2','WIN1250') FROM tbl;
ERROR: character 0x828e of encoding "MULE_INTERNAL" has no equivalent in
"WIN1250"I know I have few characters like this one in table with about 1.000.000
rows.
How to avoid such error and show eg. ? instead of error , or how to
replace such characters with some normal chars ?
seem like a bug in 8.1.4.
Database is installed on Linux (7.4.13) (Win & Linux clients work ok)
pg_dumped -> psql newdatabase < dumpedfrom7.4.13.dump
Now convert(xxx,'LATIN2','WIN1250') doesn't work properly, and raises error.
Some characters are ok , some are translated into 0x828e ?!?