PL SQL convert Big5 to UTF8

Asked By deangellopeter 0 points N/A Posted on - 10/07/2013

I am having a table with Chinese data with Big5 characters. Will PL SQL convert Big5 to UTF8, Please support me, so that I can get a solution for this conversion method.

• Status: Open
• Question Views: 2562
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: ActionScript

Answered By Alexander Jose 0 points N/A #160105

PL SQL convert Big5 to UTF8

The solution to this problem lies in Convert Function of Oracle/PLSQL which is a built-in function of this server. This function can convert a string from one character set to another.

The syntax of the Convert function is

CONVERT( string1 , char_set_to , [ char_set_from ] )

String1 is the string to be converted.

Char_set_to is the character set to convert to.

Char_set_from is the character set to convert from.

 

You can convert Big5 to UTF8 online following this link:

https://www.njstar.com/cms/unicode-to-dbcs-code-conversion

About Alexander Jose

Questions
0

Answers
100

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/18/2013
• Question Category: ActionScript