Home > database >  Novice consult oracle put Chinese in the table are hexadecimal, how to show into Chinese
Novice consult oracle put Chinese in the table are hexadecimal, how to show into Chinese

Time:10-23

This, for example, how to translate?
0 b66ec21d0c7698b6ce25c850eacbc0df40eb89963ee6764b7b0b67face75d416c476ca0a8556cedf2f7e0361d0a824009c3b27176d0cc5c245d01be57774cc6

CodePudding user response:

Please tell me about how to translate the above into Chinese, the front four 0 b66 said a 'in' word

CodePudding user response:

Anyway, already drunk, wait for the results

CodePudding user response:

"0 b66 said a" in "word" what kind of encoding rules is this??

CodePudding user response:

I don't know what code, I know the following:

4051 a19003b8a934bd9b9061104230b82e99001c36a19ded7ae32626336df5b696ef4eac5ae6b6cee87458ff7be587f4bb1b6fd18f6f2e8244e935d7538cbb3e1d6eba3d3b5acfb79a7983d1

The translation is:


When you are about to pass through the intersection, realized to the left instead of forward, the following is true?

Have a master know how coding?

CodePudding user response:

Carefully at 0 b66 doesn't say 'in' word, a bit like encryption, dizzy

CodePudding user response:

This is saved in your database is the hexadecimal code, database didn't turn again, you need to find when deposited in the database with the coding rules, to decode, this problem has nothing to do with the database again,

CodePudding user response:

Thank you, may be has nothing to do with the database, I have to read the data source, a lot of documents, coding rule should be in there, just don't know, you may ask to decrypt

CodePudding user response:

Use the utl. To_varchar2 (field)

CodePudding user response:

Using utl. Cast_to_varchar2 (field) so that you can convert hexadecimal to Chinese characters

CodePudding user response:

Utl package can deal with this thing, but it's best program to make, ORACLE is weak in this
  • Related