JetThoughts

Postgresql Insert not valid unicode values

December 16th 2009

I have an error when try insert to DB charcters not valid for Postgres in Rails application:

PGError: ERROR:  invalid byte sequence for encoding "UTF8": 0x92

Found solve, but not pretty cast all string to UTF-8 with valid characters by Kconv:

Kconv.toutf8("string with invalid characters \x92")

0x92 it is Word’s quotes in Windows-1250 or Windows-1252 encoding. So next method is: Iconv.new(‘UTF-8’, ‘Windows-1250’).iconv(text) resolve this issue.

P.S: When I search about answer on this question, I found next method to clear not unicode symbols: Iconv.new(‘UTF-8//Ignore’, ‘UTF-8’).iconv(product_line)

blog comments powered by Disqus

Powered by Rackspace Cloud Computing