OraFAQ Forum: SQL & PL/SQL » how to find no of bytes for each word or character in Oracle

Home » SQL & PL/SQL » SQL & PL/SQL » how to find no of bytes for each word or character in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find no of bytes for each word or character in Oracle [message #189526]

Fri, 25 August 2006 00:39

krs
Messages: 9
Registered: November 2001

Junior Member

Hi,

I am using Oracle 9i database.

I have some data in the database with chinese characters. I want to know how many bytes per each character in a word and get the total bytes. .

Is there any built in Oracle function or anything where i can get no of bytes for each character or a word.

I am not able to find the solution anywhere.
Any help is appreciated.

Report message to a moderator

Re: how to find no of bytes for each word or character in Oracle [message #189566 is a reply to message #189526]

Fri, 25 August 2006 02:27

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

Use vsize function to achieve your requirement. vsize returns the number of bytes in the internal representation of an expression/column.

Usage:
select vsize('abcd') from dual;

Thanks,
Thangam

Report message to a moderator

Previous Topic:	identify exception
Next Topic:	script validation against tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 21:21:54 CST 2024