String handling and encoding between Java and Oracle -


I have some code that does something like this: 

  string incoming Content = getContent (); If (incoming content.line ()> 14) {incoming content substrings (0, 14); }

GetContent () returns a string with the text "Lorem Ipsum § Lorem ipsum"

The returned string is saved in an Oracle database, but Oracle complains that the string is greater than the column size. The column size is defined as VARCHAR2 (14 BYTE) .

Why is there any idea? I suspect that this is the character in the § string but I'm not sure. I know that Oracle database only supports UTF-8, can it be the reason for wrong size / string length?

JAVA says that it is 14 letters, but Oracle thinks it is not like that.

Because the data type in oracle is byte instead of alignment CRAR Alignment You are eating out of 14 of the "slots" available at the end with any multi-byte characters. For example, VARCHAR2 (2 BYTE) will have two 1-byte characters or only one 2-byte character (and not all 3-byte characters in all). In Java, however, substring () will also count 2-byte characters in the form of a single character so that you can send a lot of data for the Oracle column.

You can use VARCAHR2 (14 CR) in Oracle (which will create 14 multi-byte characters) and make your Java programming easy, or you can Can come with an algorithm which calculates the number of bytes, trim according to a string and accordingly (make sure not to cut multi-byte characters in between).


Comments

Post a Comment

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
Read more

eclipse plugin - Run java code error: Workspace is closed -

To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
Read more

c - Error on building source code in VC 6 -

When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
Read more