Re: Length of CLOB in bytes.

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 29 Aug 2007 21:35:22 +0200
Message-ID: <46d5ca7b$0$399$426a34cc@news.free.fr>

"Thomas Kellerer" <FJIFALSDGVAF_at_spammotel.com> a écrit dans le message de news: 5jlqp1F878mU1_at_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

When database character set is multi-byte, CLOB is always stored in UCS2 whatever is the database character set.

Btw, AL32UTF8 is 1 to 4 bytes per character.

Regards
Michel Cadot Received on Wed Aug 29 2007 - 14:35:22 CDT