Home » SQL & PL/SQL » SQL & PL/SQL » How to calculate the Bytes of multibyte character. (windows)
How to calculate the Bytes of multibyte character. [message #325140] Thu, 05 June 2008 02:17 Go to next message
Messages: 1
Registered: June 2008
Location: NOIDA
Junior Member

How to calculate the bytes of a multibyte characters.

For e.g As in Japanese Language there are two types kana and kanji and kana takes just 1 byte and kanji takes 2 bytes so my question is if any of them comes as my data then how will we check that this is a kanji type or kana though I have put a validation of lenght but that is just calculating the length but cant identify that it is of 1 byte or 2 :p byte.
Re: How to calculate the Bytes of multibyte character. [message #325148 is a reply to message #325140] Thu, 05 June 2008 02:55 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Length depends on you character set. Either it fixed length one and so all data are the same length and it easy , either it is *UTF8 family and it is variable.
In anycase you can have the number of bytes using lengthB instead of length.

Please don't rate your post before there is any answer. We are pretty sure you are satisfied by your question but everyone is satisfied with his question.

Previous Topic: Timestamp column
Next Topic: [Connect By] Clause Problem
Goto Forum:

Current Time: Fri Aug 18 15:23:42 CDT 2017

Total time taken to generate the page: 0.17665 seconds