You've probably guessed from my recent posts that I know very little
about how character sets work in Firebird. Let me describe my latest
problem (which if solved will probably help understanding the previous
problems I had):

We have a database of music and movie products and each product can
have a review or synopsis which is currently stored in a blub sub_type
1 character set utf8 field. All of the reviews/synopses come from
other websites - I'll use http://www.ezydvd.com.au/item.zml/800183 as
an example. If I copy and paste the review (starting at It's Season
Three down to the last episode) into a TDBMemo and save it I get a
'Malformed string' error. So I pasted the review into notepad, saved
it and opened it up in a hex editor. The problem saving it to the
database is because of the single and double quotes. In the hex editor
their values are 0x92, 0x93 and 0x94. According to Firefox the web
page is using ISO8859-1 encoding, in which 0x92, 0x93 and 0x94 are all
reserved for private use.

At that is where my understanding ends, which is to say I have none. I
think I have 2 problems, 1) I don't know of any way of telling the
encoding of the text pasted into the memo, and 2) how to convert that
into something that Firebird understands.

If anyone able to offer any advice on this, or how character encoding
should be handled generally when trying to insert it into a Firebird
database?

TIA