![]() To get all the valid character sets, you query them from the V$NLS_VALID_VALUES view as follows: SELECT value FROM Microsoft Windows Traditional Chinese Code ISO 8859-1 West European 8-bit character set Unicode 3.0 Universal character set CESU-8 encoding form Japanese Shift-JIS Character Set, compatible with MS Code Unicode 5.0 Universal character set UTF-8 encoding form The following table shows the common character sets: Character Set ![]() Note that the result is the same as converting the string from the WE8ISO8859P1 character set to the US7ASCII character set. The following statement illustrates how to convert the character set of a string from Latin-1 to ASCII. The following example converts a string from ANSI to UTF8: SELECT CONVERT( 'ABC', 'utf8', 'us7ascii' )Ĭode language: SQL (Structured Query Language) ( sql ) ![]() The CONVERT() function returns a string in the converted character set. This argument is optional and its default value is the database character set. Is the name of the character set that is used to store the string_expression in the database. Is the name of the character set to which the string_expression is converted to: Is the string whose character set should be converted. The Oracle CONVERT() function accepts three arguments: The following shows the syntax of the Oracle CONVERT() function: CONVERT(string_expression,to_data_set) Ĭode language: SQL (Structured Query Language) ( sql ) Arguments Note that the CONVERT() function is often used to correct data stored in the database with a wrong character set. The Oracle CONVERT() function converts a string from one character set to another.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |