Hello,
 When i save UTF8 in a CLOB field it does dispay garbage. (for non-english items, using Utf8Encode)
 Is there any way to store UTF8 (Utf8Encode) in a CLOB field ?

Thank you

Charalampos


Ansi or unicode table?

Roy Lambert

> Ansi or unicode table?

Hello Roy,
 Unicode table

On 2/26/2017 1:10 PM, Charalampos Michael wrote:
> Hello,
>   When i save UTF8 in a CLOB field it does dispay garbage. (for non-english items, using Utf8Encode)
>   Is there any way to store UTF8 (Utf8Encode) in a CLOB field ?

AFAIK EWB (and Delphi) are UTF16 for storage so you'd need to write your
own viewer (for anything not ansi). Main challenge though is actually
storing and reading data - using things like asstring in dataset and
other string operations cane easily result in utf16.

You could use blob and be very careful when reading/writing data to
ensure it does not get converted again by dataset or other libraries.

Raul

Michael,

<< When i save UTF8 in a CLOB field it does dispay garbage. (for non-english items, using Utf8Encode) Is there any way to store UTF8 (Utf8Encode) in a CLOB field ? >>

Is there any particular reason that you wish to store it as UTF-8 and not just leave it as UTF-16 ?  Normally you would use an *ANSI* database for storing/retrieving data as UTF-8 in order to realize the savings in terms of actual byte usage.

Tim Young
Elevate Software
www.elevatesoft.com