"0000" consecutive zeros cannot be saved to the oracle database in the form of a string

question background

A field type in both the database table and the entity class is a string type, but in the case of consecutive zeros, the actual storage in the database is "0"-zero.

try

has tried non-zero numbers, which is normal, so consider whether it is caused by some policy of ORACLE
tried to add a space "0000" to the beginning and end, which is also invalid

expected answer

whether there is a strategy for oracle: for the data character type "0000000." Do the head and tail blanks and then re-operate?
how can I avoid this strategy if I want to implement data with an error format of "0000"?

Oracle java

Jul.06,2021

Please give a simplified version of the code that can reproduce the problem
including table statement

it is recommended to insert a record directly into the database to see if it is saved properly to confirm whether the data changes are on the application side or the database side.

oracle does not process the values of character fields, so you can check whether there is a custom trigger on the table.

Previous: Using webpack and sass to package @ media in two scss files is not valid, what to do?

Next: Why is CPP looping to assign values to character arrays?

Why do I set the isolation level of the database and still produce dirty read data when I call the method to update the system prompt?
...

Transaction oracle java

Mar.09,2021
There is a difference in the value of number conversion between long in java and number in database.
1. The number of bank card digits entered by the user on the page is relatively long, so the server is loaded with long type. when saved in the oracle database, the viewing data becomes a scientific notation tag. (it is said on the Internet that the le...

Mybatis oracle java

Mar.28,2021
How to write Mybatis
the first one: write in java. @ Select ( "select bureau_code from drt_opr_area ") List < String > getAllAreas (); the second: write in xml. < select id= "selectList " resultMap= "BaseResultMap " parameterType= "com.csg.intshop.entity.DrtShopConfi...

Oracle java

Mar.28,2021
The plsql connection oracle, code is set up, and the data is queried in normal Chinese, so why is the comment garbled alone?
...

Oracle java

Mar.30,2021
Java connects to the oracle database and can run normally, but the console will keep reporting errors.
java.sql.SQLException: Io : Bad packet type at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:...

Oracle java

Feb.18,2022
Why is it that when String type asks for SUM, the query speed with round, is very fast, and the query speed without round, is very slow?
Why is it that when executing a SUM query in the code, the query with round (), is fast, the query without round (), is slow, and the execution speed is fast in Navicat? 1, xml file, add round () sql: 2xmlround sql: ...

Oracle java struts

Feb.21,2022
Javaweb project, why do you lose your connection to the database after a period of time?
--- Cause: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185) at com.ibatis.sqlmap.engine.mapping.s...

Oracle java

Mar.02,2022
Win10 computer is equipped with a vmware virtual machine and centos. How can I access centos's oracle database from win10?
oracle is installed on centos, and centos is installed on win10 s virtual machine on a notebook how do I use this win10 laptop to access the oracle database on the internal virtual machine (centos)? ...

Oracle java

Apr.11,2022
[mybatis] ask about the case setting of key when resultType is defined as Map
I would like to ask you that when I use mybatis to execute sql to get data, I define the mapping in xml as follows: <select id="testQry" parameterType="hashmap" resultType="hashmap"> SELECT DISTINCT username FROM t_u...

Eclipse oracle java

Apr.15,2022