Home » SQL & PL/SQL » SQL & PL/SQL » how to find no of bytes for each word or character in Oracle
how to find no of bytes for each word or character in Oracle [message #189526] Fri, 25 August 2006 00:39 Go to next message
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.
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 Go to previous message
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

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


Current Time: Fri Dec 09 19:36:40 CST 2016

Total time taken to generate the page: 0.16774 seconds