Re: Length of CLOB in bytes.

From: Thomas Kellerer <FJIFALSDGVAF_at_spammotel.com>
Date: Wed, 29 Aug 2007 20:04:16 +0200
Message-ID: <5jlqp1F878mU1@mid.individual.net>

Michel Cadot wrote on 29.08.2007 18:18:
> "Krivenok Dmitry" <krivenok.dmitry_at_gmail.com> a écrit dans le message de news:
> 1188392926.048622.156580_at_57g2000hsv.googlegroups.com...
> | Hello!
> |
> | Is there a way to get the length of a CLOB in bytes (not in chars)?
> |
> | Thanks!
> |
>
> dbms_lob.getlength if your database is single byte character set
> 2*dbms_lob.getlength if your database is multi byte character set

What about UTF8?
With that encoding one character can be between 1 and 3 bytes...

Thomas Received on Wed Aug 29 2007 - 13:04:16 CDT