| Subject | Re: Bug converting UTF8 BLOB to client charset in Firebird 2.1.4 |
|---|---|
| Author | Fabiano |
| Post date | 2011-04-06T10:11:12Z |
Hi again!
Just found out the problem, and i´m going to register so others can follow.
The field content is stored correctly in UTF8, and Firebird is corretly converting it to the client charset.
The problem was the content was a UTF8 XML file and i was connecting using ISO-8859-1 charset from both IBExpert and Delphi.
When i ran the query, Firebird converted the field from UTF8 to ISO-8859-1 (as expected), and when i saved the file it was saved using ISO-8859-1 encoding, while the XML content explicitly expected UTF8 ("<?xml version="1.0" encoding="UTF-8" ?>")
Fabiano
Just found out the problem, and i´m going to register so others can follow.
The field content is stored correctly in UTF8, and Firebird is corretly converting it to the client charset.
The problem was the content was a UTF8 XML file and i was connecting using ISO-8859-1 charset from both IBExpert and Delphi.
When i ran the query, Firebird converted the field from UTF8 to ISO-8859-1 (as expected), and when i saved the file it was saved using ISO-8859-1 encoding, while the XML content explicitly expected UTF8 ("<?xml version="1.0" encoding="UTF-8" ?>")
Fabiano