Re: [GENERAL] How to avoid error with convert() function

2006-09-25 Thread zeljko
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

[GENERAL] How to avoid error with convert() function

2006-09-23 Thread zeljko
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